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]
