Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / Neetu Sinha
DBMS_STATS offers several benefits over ANALYZE:
1. Automatic sampling: DBMS_STATS collects statistics based on a sample of data blocks, which reduces the I/O overhead and improves performance compared to full-table scans performed by ANALYZE.
2. Customizable sampling method: You can configure the sampling method (e.g., DBMS_STATS.SET_SAMPLING) according to your specific requirements, unlike with ANALYZE which uses a fixed block sampling method.
3. Automatic gathering of statistics for index-organized tables and materialized views.
4. Dynamic performance tuning: DBMS_STATS can be scheduled as part of a database maintenance job to ensure that statistics are always up-to-date, helping to maintain optimal query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to put more than 1000 values into an oracle in clause?
How to write a left outer join with the where clause in oracle?
What is oracle latest version?
How to use values from other tables in update statements using oracle?
How to start an oracle instance?
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to select all columns of all rows from a table in oracle?
