>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.

Dmitry,
PMFJI but even with no indexes, nothing for optimization etc 5mins sounds too much for 150K records. Sounds like there is a problem in table header to me. Can you create a fresh copy of that table and try (with or w/o indexes, shared or exclusive).
Networked? Faulty HW?
Cetin