Clear SYS(3054, 1) Set Deleted On Set Collate To "GENERAL" ? ? "I'm using a binary index - Collate: General" Create Table MyTest (MyId I, Name C (50)) ? Cpdbf(), CpCurrent() Index On Deleted() Tag DeletedTag Binary Index On MyId Tag MyIdTag Index On Name Tag NameTag Insert Into MyTest Values (1,"Joao Bernardo") Insert Into MyTest Values (2,"João Alberto") Insert Into MyTest Values (3,"Joao Gustavo") Select * From MyTest Where Name Like "J%" Order By Name Close Databases All Erase MyTest.dbf Erase MyTest.cdx ? ? "I'm not using a binary index - Collate: General" Create Table MyTest (MyId I, Name C (50)) ? Cpdbf(), CpCurrent() Index On MyId Tag MyIdTag Index On Name Tag NameTag Insert Into MyTest Values (1,"Joao Bernardo") Insert Into MyTest Values (2,"João Alberto") Insert Into MyTest Values (3,"Joao Gustavo") Select * From MyTest Where Name Like "J%" Order By Name Close Databases All Erase MyTest.dbf Erase MyTest.cdx Set Collate To "MACHINE" ? ? "I'm using a binary index - Collate: Machine" Create Table MyTest (MyId I, Name C (50)) ? Cpdbf(), CpCurrent() Index On Deleted() Tag DeletedTag Binary Index On MyId Tag MyIdTag Index On Name Tag NameTag Insert Into MyTest Values (1,"Joao Bernardo") Insert Into MyTest Values (2,"João Alberto") Insert Into MyTest Values (3,"Joao Gustavo") Select * From MyTest Where Name Like "J%" Order By Name Close Databases All Erase MyTest.dbf Erase MyTest.cdx ? ? "I'm not using a binary index - Collate: Machine" Create Table MyTest (MyId I, Name C (50)) ? Cpdbf(), CpCurrent() Index On MyId Tag MyIdTag Index On Name Tag NameTag Insert Into MyTest Values (1,"Joao Bernardo") Insert Into MyTest Values (2,"João Alberto") Insert Into MyTest Values (3,"Joao Gustavo") Select * From MyTest Where Name Like "J%" Order By Name Close Databases All Erase MyTest.dbf Erase MyTest.cdxIf you run this code, you will see that just the third Select is FULL optimizated. The others is just PARCIAL.