Dmitry,

What are the exact index expression(s)? What does sys(3054,11) display? Is SET DELETED ON? Do you have an index on deleted()?

>I am trying to improve a speed of a SQL query. Currently the query looks like this:
>
>

>select MYFIELD from MYTABLE where MYFIELD1 = "00"
>

>
>Note that the table has index tag on field MYFIELD1.
>The customer says that working against a table of about 150,000 record this takes up to 5 minutes.
>
>I want to add two more conditions to the query, both on fields that have index tags. Therefore the query will look like following:
>
>

>select MYFIELD from MYTABLE where MYFIELD1 = "00" and MYFIELD2 = "O"
>and MYFIELD3 = "C"
>

>
>I know that the table has much fewer records on the MYFIELD2 = "O" and then within those there are some small number where MYFIEL3 = "C", and then within those there are some that have MYFIELD1 = "00".
>
>My question is, does it matter in which order I will put the WHERE expression in the above SQL Select?