Hi All,
RE: DBMS_UTILITY.ANALYZE_SCHEMA()
Any thoughts on what is a sensible percentage
to use for estimate statistics? Is 5% enough
to allow the optimizer to make sensible decisions?
OR I could use 10,000 rows, and that would be more rows
than most of my dimension tables (I presume 10,000
rows means 10,000 rows or *up to* 10,000 if that
many exist) - However, 10,000 rows is only a tiny
fraction of my fact table.
Any thoughts, experiences?
Steve
--
"The floggings will continue until morale improves."
Received on Thu Jun 18 1998 - 14:12:24 CDT
