Re: How to avoid gathering column statistics by using dbms_stats.gather_table_stats

Originally I had left the paramter method_opt unspecified and this would cause the process to take for ever. I saw in the SQL_TRACE that it was trying to run a very complex sql for collecting column stats and wanted to have the option to gather table statistics without column statistics.

In this way we would be able to gather only table statistics for tables we are interested in by using a uniform call to gather_table_stats and then we could use a calls to gather_column_stats for the columns that we would be interested in.

D Received on Wed Oct 12 2005 - 16:25:06 CDT