For best results on large tables, collect SUMMARY statistics only on non-partitioned tables. Other recommendations for large tables include collecting statistics on:
- All indexed columns
- All frequently joined columns
- Columns frequently referenced in WHERE clauses, particularly if the column contains very skewed, nonunique data
- The system-derived column PARTITION (for all row and column-partitioned tables)