how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

how the Oracle Prepares the Execution Plan and how it
chooses the Optimal one?

Question Posted / jakki

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

Explain integrity constraints?

How to change program global area (pga) in oracle?

How to find the duplicate rows count from employees table in oracle?

How to create additional tablespaces for an new database?

what is main def between plsql/table and array?

Is oracle a language?

What do you mean by a database transaction & what all tcl statements are available in oracle?

How many anonymous blocks can be defined?

How to load excel data sheet to oracle database

Which database is better for os platform dependency?

What are the varoius components of physical database structure of oracle database?

For more Oracle General Interview Questions Click Here