Indexing not working

| 2494 | | | qb_test_result_details | ref| resultId | resultId | 4 | qb_test_result.id | 45 | | | qb_test| eq_ref | PRIMARY,companyAuthor | PRIMARY | 2 | qb_test_result.testId |1 | Using where | | qb_question| eq_ref | PRIMARY | PRIMARY | 4 | qb_test_result_details.questionId |1 | | +++---+--+-+---+--+-+ Thank you Sajith A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Indexing not working

MARY" 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:

Re: Indexing not working

Thank you Mathias once again > 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. Initially while posting... i tried to reduce one table to avoid complexity from the actual query. I'm

Re: Indexing not working

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 -- MySQL General Mailing List For list archives: http://lists.