DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Quick Question I Hope

Threaded View

  1. #1

    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
  •  


Click Here to Expand Forum to Full Width