Quick Question I Hope

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

WTF is sargable?

yes, it's sargable.

Quote:

---

Originally posted by marist89
WTF is sargable?

---

Hey, STFW buddy!

:)

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.

Quote:

---

Originally posted by slimdave
Hey, STFW buddy!

:)

---

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

Quote:

---

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.

Quote:

---

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