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

Reply via email to