auto_sample_size doing full table scans

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Wed, 24 Apr 2013 13:59:23 -0400
Message-Id: <5177E53B0200000B00501AE0_at_groupwise.gcrta.org>

I am running the below code snippet and it seems to do a full table scan rather than sampling. Sample size and num rows are equal. Any ideas why. This is 11.2.0.3.  

dbms_stats.gather_table_stats(

	ownname => 'XXX',
	tabname => 'ACTION2',
	method_opt => 
	'for all columns size 1 ',
	estimate_percent => dbms_stats.auto_sample_size,
	cascade => true,
	degree => 8);
 
 

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 24 2013 - 19:59:23 CEST