Question: what is the difference between logical index and physical index?
Answer: SQL Anywhere uses physical and logical indexes. A physical index is the actual indexing structure as it is stored on disk. A logical index is a reference to a physical index. ... If one does not exist, the database server creates a new physical index and then points the logical index to it.