Quick Question I Hope

[Bruce Trimpop]

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

[marist89]

WTF is sargable?

[slimdave]

yes, it's sargable.

[slimdave]

Originally posted by marist89
WTF is sargable?

Hey, STFW buddy!

[Bruce Trimpop]

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

[Bruce Trimpop]

Thanks slimedave. Is there particular documentation you can point me to that would cover this topic?

Thanks

[slimdave]

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.

[marist89]

Originally posted by slimdave
Hey, STFW buddy!

..|.. (A New Jersey horn for those of you that don't know x-rated emoticons)

[slimdave]

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.

[DaPi]

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 . . .