-
DBMS_STATS Vs ANALYZE
Question 1
===========
Let us take this example..
begin
DBMS_STATS.GATHER_TABLE_STATS('INVENTORY','SALES', METHOD_OPT => 'FOR COLUMNS SIZE 1 ERDAT');
end;
What is FOR COLUMNS SIZE 1 ?. What does it mean the number 1?
Question 2
==========
I was reading this link ..
http://www.dbspecialists.com/special...st2005-01.html
From this link, DBMS_STATS is good when we compare to ANALYZE statment due to below points.
1. DBMS_STATS has parallel statistics collection
2. DBMS_STATS gathering statistics only when existing statistics are stale
3. gathering partition-level and subpartition-level statistics
4. GATHER_SYSTEM_STATS is not available in ANALYZE
My question is, does DBMS_STATS gather statistics
when existing statistics are stale??
Question 3
=========
does ANALYZE command generate Historgrams?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|