Ask about statistics on partition table ?
With partition table, Can we use script on single table to gather statistics such as ?:
begin
dbms_stats.gather_table_stats(
ownname => 'XBANK',
tabname => 'T_PRODUCT',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all columns size auto',
cascade => true
);
end;
My DB is 9.2.0.4
Thanks.