diffrence between estimate statistics and compute statistics
What is the difference between
analyze table compute statistics
analyze table estimate statistics ?
What is the default % (60% or 70% or 25% or ? ) in the second
defualt for estimate is 1064 rows as sample if you omit it.
Compute : 100% ( all rows )
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Compute : Computes Statistics for whole Table(for all rows).
Estimate: - Computes Statistics on sample of rows over the table.
- Be default, its 1064 rows.
- You can specify rows in numbers or in percentage of total rows.
- If the number or percentage of rows exceeds 50%, Statistics will be computed on all rows in Table.
also, you should be using DBMS_STATS instead of the analyze command.
you can also get the option of sampling by % of rows or by % of blocks.
Click Here to Expand Forum to Full Width