Re: How to force use of an index.

Steve Proctor wrote: > > Online version 5 > > I've got a very slow select wihch I've analysed using set explain on. > > I know it would be quicker if I could force it to use a particular index > for it's main index path. > > Any ideas how to force the optimiser to use an index? Yes, look in the FAQ ! Example : select * from yourtable where field1=? and field2=2 and field2=2 and field2=2... The optimizer gives more 'weight' to the column 'field2'. Can you try and tell me ??? Valery (valou@hotmail.com) Bye