-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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!
-
Originally posted by pando
also RULE cannot be used, his tables are partitioned!
This was something i had doubt, but clear now
(i some where had read that, but still suggested to use Rule so that some one will yell at me )
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Bottom Line: Every one can have a brain fart. Live with it!
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|