SQL Tip: Using Union instead of OR

In this video we cover a tip that you might want to use when you run into a poorly performing query that has a where clause containing OR's. We go into some depth and include a walk through in SSMS.
If you would like to submit a question please drop it below!
Company Website
www.serverside-ts.com
Contact Email: [e-mail]

[@aqilzamani6924]

thank you , it was very nice for tunning or in where clauses.
i am new to oracle is there similar thing like
set statistics io , time on
and execution plan to analize in oracle ?

[@sqlanswers]

Yes, Oracle does have something similar called autotrace. You enable in SQL Plus with "SET AUTOTRACE ON". The key metric I look at is named consistent gets. You can associate consistent gets with Logical Reads in SQL Server. Autotrace will also provide query plan information.