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

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

How to create a server parameter file?

What is the minimum client footprint required to connect c# to an oracle database?

What is a package ? What are the advantages of package ?

Explain an exception?

Difference between pre-select and pre-query

What do you mean by redo log file mirroring?

In oracle there is column command, how will you explain that?

what is difference between table and view? where to use views? thanks in advance!

How to import one table back from a dump file?

How to define a data source name (dsn) in odbc manager?

Explain the use of full option in exp command.

For more Oracle General Interview Questions Click Here