Single column and multicolumn stats

Database
1 REPLY
Enthusiast

Re: Single column and multicolumn stats

Just a general recommendation... if you are going to collect any stats on a table at all, the first statistic you should collect on is the primary index columns (together, not separately).

Collecting on the columns separately may also be required if you have frequent queries that specify constraints for one column or the other, but not both.