Re: Indexing not working

[gerald_clark]

Sajith A wrote:

Thank you Clark for your time

Try using straight joins to force MySQL to join from qb_test_result first.
The order chosen by the optimizer has no use for keys from this table.

I tried to force indexes.. but it didn't help
Thank you

Since the query you supplied cannot use an index, force index won't help.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]