if you use RULE hint you know it is going to use all the indexes anyways so what´s the point trying something you know already?
Printable View
if you use RULE hint you know it is going to use all the indexes anyways so what´s the point trying something you know already?
The point here is soleley not to use Index, but to see how it benifits or still degrades the performace..
Well in his post he did mention even by using Index hint CBO didnt prefer..but he feels indx usage will better, so what wrong to use Rule hint and see ?
Abhay.
he said he hint the query but still index wasnt pick up and that must because he used the wrong syntax!
also RULE cannot be used, his tables are partitioned!
This was something i had doubt, but clear now :)Quote:
Originally posted by pando
also RULE cannot be used, his tables are partitioned!
(i some where had read that, but still suggested to use Rule so that some one will yell at me ;) )
Abhay.
Bottom Line: Every one can have a brain fart. Live with it!