Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of ANALYZE command ?
- 3 Answers
- 7034 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
To perform one of these function on an index,table, or cluster:
- to collect statisties about object used by the
optimizer and store them in the data dictionary.
- to delete statistics about the object used by
object from the data dictionary.
- to validate the structure of the object.
- to identify migrated and chained rows of the table or
cluster.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / shailendra kumar
ANALYZE commmand is use the gather the statisties of the
table,index and current setuation of table. this is use the
analye the performance of the table. for example row
migation and row channing etc.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / nishi
When we issue ANALYZE TABLE with the computes statistics command, the entire Oracle table is analyzed via a full-table scan. Upon completion of the Oracle ANALYZE TABLE command, very accurate statistics are then placed inside the data dictionary for use by the cost-based optimizer.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is meant by physical order and logical order in clustered index and non clustered index.
What are the roles and user accounts created automatically with the database ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
What are the use of Roles ?
What are the benefits of distributed options in databases ?
How can we specify the Archived log file name format and destination ?
what is the step for rmanbackup?
What are the database administrators utilities avaliable ?
What are the various type of snapshots ?
What are the dictionary tables used to monitor a database spaces ?
What is default tablespace ?
what is different between view and sequence?
Oracle General 
