SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OR and UNION

620262Jan 29 2008 — edited Jan 29 2008

Is there any difference between OR condition in where clause and set operator UNION?
i tried queries with OR condition in where clause and then split that query in two queries with UNION set operator.
i have tested for some queries and its giving me the same output but i am not sure is this the right approach for performance tunning purpose.

please suggest for the same.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2008

Added on Jan 29 2008

3 comments

463 views