Hi Sajith, I tried to recreate you tables and do some tests, but i don't have significant data. So i don't take your explain plan.
I suggest you to test after optimize table ... and analyze table ... if you stay with the problem and you can give me a set of data, i'll try to help more. Mathias Selon Sajith A <[EMAIL PROTECTED]>: > Thank you Mathias for your time... > > > have you created an index on (id, testId) ? > > i can't see the other indexes ? The only ones are the PK and testStudent, > so the > > PK is used. > Yes i also tried that .. but it was not getting used.. it listed as > the possible_keys "PRIMARY" and "testStudent" but the "key" value was > NULL.. I tried to index all combination of fields in qb_test_result.. > but nothing was getting use.. Am i doing something wrong in the > query? > > Thank you > Sajith A > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
