KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a set of conditions in my where clause like WHERE d.attribute3 = 'abcd*' AND x.STATUS != 'P' AND x.STATUS != 'J' AND x.STATUS != 'X' AND x.STATUS != 'S' AND x.STATUS != 'D' AND CURRENT_TIMESTAMP - 1 < x.CREATION_TIMESTAMP Which of these conditions will be executed first? I am using oracle. Will I get these details in my execution plan? (I do not have the authority to do that in the db here, else I would have tried)
Tags (comma-separated)
Save Edits
Cancel