|
-
Explain Plan of a query
I have a query regarding explain plan.
In the following query
Select customer_name from customer
where
customerid=1234
OR :s_status = 1
In case the value being passed in s_status is not 1.
Will the index on customerid will still be suppressed i.e whether the explain plan will be generated with the bind_variable taking OR condition in consideration (i.e doing a full scan on Customer) or
with the actual values at the run time.
In short is the explain plan is generated during parsing only or while
executing it with the values being passed in the bind variables.
regards
nik
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|