Hi

I have the following problem

I have a table with 3 fields ('Field_A', 'Field_B', 'Field_C')
My query is:

Select Field_A from table where Field_b=10 order by Field_c ASC;

I have performance issues even when i have tried to define index for this table How should i define the corerct index (by the where or by the priority or both?)

Regards, Yariv


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to