How would you go about generating an EXPLAIN plan?

Question Posted / guest

How would you go about generating an EXPLAIN plan?..

Answer / gogune

Thr'u command

explain plan for <select statement>

Is This Answer Correct ?

0 Yes

1 No

More Oracle AllOther Interview Questions

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

What is the difference between oracle media recovery and crash recovery?

What is auto invoicing? Explain : oracle accounts receivable

Can We Restore a Table that accidantly dropped.

How would you determine what sessions are connected and what resources they are waiting for?

For web applications from which version of Oracle is suitable?

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

Explain materialized views and how they are used.

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

What does coalescing a tablespace do?

Name three advisory statistics you can collect.

For more Oracle AllOther Interview Questions Click Here