>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?
>
>Thank you.
Check that CPDBF() and CPCURRENT() are identical!