what is analyze command ? what kind of statistics does it
generate?

Answer Posted / brahma prakash

It Analyze the cost of the query with shortest excution path

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by a database object?

681


what are steps for interface? where is exchange rate defined in which table?

1593


What is the dynamic sql in oracle?

690


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

642


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1524






Is oracle a language?

602


what is Single Byte Overhead...?

2148


How to convert characters to numbers in oracle?

674


What is the difference between Delete, Truncate and Drop in Oracle?

698


How to list all tables in your schema?

692


How to drop a stored procedure in oracle?

678


What is oracle in java?

624


How would you best determine why your MVIEW couldnt FAST REFRESH?

1511


Explain oracle instance.

759


How to start a specific oracle instance?

681