Re: Force index command in sql query

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 i

Re: Force index

USE INDEX FORCE INDEX IGNORE INDEX See the manual 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 S

Re: force index

Hi! On Jun 27, Daniel Rossi wrote: > sorry i worked it out put it after the table , i got some interesting results > > Queried The Database 1 times for 9.9892050027847 seconds > > +---+--+--+--+-++--+-+ > | t