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 IS CARTESIAN PRODUCT?

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

the user should know to which database he is connected currently in oracle

What are different types of receipt reversals ? Explain them : oracle accounts receivable

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

Where in the Oracle directory tree structure are audit traces placed?

Explain the payment term in ar. : oracle accounts receivable

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

what are the advantages of Oracle over other databases..? please give me reply...

default triggers available for reports

How do you use trigger to create mutating state of table

How client makes connection with server in client/server architecture?

For more Oracle AllOther Interview Questions Click Here