What are the different approaches used by Optimizer in
choosing an execution plan ?
Answer Posted / nishi
Rule-based and Cost-based.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Describe an oracle table?
How do I limit the number of rows returned by an oracle query after ordering?
How to create a table index?
How to bring a tablespace online?
What is meant by a deadlock situation?
what is the difference between data migration and production migration.
How to work with data objects interactively?
material view and view disadvantages?
Can objects of the same schema reside in different tablespace?
How oracle handles dead locks?
How to use "in" parameter properly?
What is memory advisor in Oracle?
Explain constraining triggers.
How would you begin to troubleshoot an ORA-3113 error?
How remove data files before opening a database?