In the first query, mysqld could get all the information it
needed from table a from the index file.
In the second query, it needed to read the data file to get all
the columns, and determined that using an index would not gain
any speed. From the 3 reow returned, I woul guess that you
don't hav
0 February 2001 07:30
To: MySQL Maillin List
Subject: Index Question(again).
No Body answered my previous mail.
plz help me.
I have three tables.
i) student_info3
i) grade_ex3
i) test_info
and, There are those Index
In student_info3 table : index(student_no)
In grade_ex3 table : index(student_n
No Body answered my previous mail.
plz help me.
I have three tables.
i) student_info3
i) grade_ex3
i) test_info
and, There are those Index
In student_info3 table : index(student_no)
In grade_ex3 table : index(student_no, test_no)
In test_info table : index(test_no)
When I use t
