-
Quick Question I Hope, non-sargable expr
I'm coming from a MS SqlServer background. I have an Oracle project I've been asked to work on. Does Oracle SQL have optimization restrictions on where clauses that would make the query non-sargable?
For example: select * from table where x <> y
Under MSSQL the "not equal to" would make the clause non-sargable by the query optimizer.
Thanks
Last edited by Bruce Trimpop; 03-22-2004 at 03:07 PM.
-
-
-
Originally posted by marist89
WTF is sargable?
Hey, STFW buddy!
-
Sargable defined!!
Sorry, MS term for searchable arguments, SARGable meaning an index will be used, non-SARGable meaning an index won't be used.
This tends to be one of those issues that's darned hard to find info, I was hoping to shortcut the search by asking here first.
Thanks
-
Thanks slimedave. Is there particular documentation you can point me to that would cover this topic?
Thanks
-
you could look at the Concepts Guide and the Performance documents at http://tahiti.oracle.com for details of the optimizer.
Have a look at index hints also ... you might find that you have to prompt the use of an index to get the optimizer to use it.
-
Originally posted by slimdave
Hey, STFW buddy!
..|.. (A New Jersey horn for those of you that don't know x-rated emoticons)
Jeff Hunter
-
Originally posted by marist89
..|.. (A New Jersey horn for those of you that don't know x-rated emoticons)
In my country, we say ..V.
-
Originally posted by slimdave
In my country, we say ..V.
Slim, it's things like that that show you up as a foreigner. I can swear in French as well as any, but when I get exited it's two fingers and they know at once . . .
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
|