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