USE INDEX FORCE INDEX IGNORE INDEX
See the manual <http://dev.mysql.com/doc/mysql/en/join.html> for details.
Michael
ninjajs wrote:
Hi,
A table have index1 and index2.
A SQL use index1 on Table A.
I'd like to use index2 on Table A.
How can I do for using index2?
ORACLE has SQL hint which is force SQL execution plan.
Thank you for your advice.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
