Since oracle seems to be pushing the dbms_stats.gather_stats procedure for
getting table statistics. Do you run a separate analyze command to find
the number of chained rows since gather stats does not get this value. Or
are you still using "analyze".
Jeffrey Beckstrom
Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 |
- RE: how determine chaining if using gather_stats Jeffrey Beckstrom
- RE: how determine chaining if using gather_stats Shevtsov, Eduard
- Re: how determine chaining if using gather_stats Nuno Souto
- RE: how determine chaining if using gather_stats Mark Leith
- Re: how determine chaining if using gather_stats MHately
- RE: how determine chaining if using gather_stats Jeffrey Beckstrom