OraFAQ Forum: SQL & PL/SQL » OR clause degrades performance of a query?

Home » SQL & PL/SQL » SQL & PL/SQL » OR clause degrades performance of a query? (Oracle database, any, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OR clause degrades performance of a query? [message #670861]

Mon, 30 July 2018 07:53

raresn
Messages: 2
Registered: July 2018

Junior Member

Hello SQL Experts,
I was digging this forum in my search for an answer, but without much luck.
Does anyone knows if under SQL the "OR" clause degrades the performance of a query?
Do we have any alternatives other than union?

I would very much appreciate an answer.

Best regards!

Report message to a moderator

[Message index]

		OR clause degrades performance of a query? By: raresn on Mon, 30 July 2018 07:53
		Re: OR clause degrades performance of a query? By: cookiemonster on Mon, 30 July 2018 08:11
		Re: OR clause degrades performance of a query? By: raresn on Mon, 30 July 2018 08:31

Previous Topic:	Performance of Stored Programs
Next Topic:	Create JSON from SQL 12C R1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:07:38 CDT 2024