Force index command in query

2010-01-12 Thread Jeetendra Ranjan
Hi, After analysing slow query log i found that some queries are not using index and so i used the force index command in query and test it and now it starts using index properly.Accordingly i implemented the same query with force index in my application code and regeneratet the slow query log

Re: Force index command in sql query

2009-12-09 Thread Jesper Wisborg Krogh
On 09/12/2009, at 5:10 PM, Jeetendra Ranjan wrote: Hi, After analysing slow query log i found that some queries are not using index and so i used the force index command in query and test it and now it starts using index properly.Accordingly i implemented the same query with force index

Force index command in sql query

2009-12-08 Thread Jeetendra Ranjan
Hi, After analysing slow query log i found that some queries are not using index and so i used the force index command in query and test it and now it starts using index properly.Accordingly i implemented the same query with force index in my application code and regeneratet the slow query log

Re: Force index

2005-02-03 Thread Michael Stassen
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 whi

Force index

2005-02-03 Thread ninjajs
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

Re: force index

2003-06-27 Thread Sergei Golubchik
; | r | eq_ref | PRIMARY,reporterID | PRIMARY | 1 | sl.reporterID | > 1 | | > | tt| eq_ref | PRIMARY,tape_typeID | PRIMARY | 1 | sl.tape_typeID | > 1 | | > +---+--+-----+--+-+---

force index

2003-06-26 Thread Daniel Rossi
| | +---+--+-+--+-++--+-+ the first was using the force index, the second was without so is adding to force to use and index going to make it slower ? -- MySQL General Mailing List For list archives: http

example of using FORCE INDEX

2003-06-26 Thread Daniel Rossi
hi there i dont think this will help any further on my full text searching but i would like an example of how to use FORCE INDEX , there is no example on the mysql site and the hint is misleading i am getting sql errors , lemme know thanks -- MySQL General Mailing List For list archives: http