>I have a table called NOTE that is used as a Memo field (this was before they were created).
>
>It is indexed on NO_CODE and here is a Select I ran for it:
>
>SELECT * FROM Note WHERE No_Code = "EZ 25329REASON "
>
>This query takes around 1 minute to run, the table is 270MB in size and has 2.8 million records and the field length of NO_CODE is C15.
Is your index
upper(no_code) tag no_code? If so, you get optimization in the select bu using the exact expression used in the index -- ...where upper(no_code) = ...
You migth also elimate any index tag on deleted().
Mark McCasland
Midlothian, TX USA