How the Query Optimizer Uses Statistics

When the query optimizer in SQL Server 7.0 examines the distribution statistics of a composite index, does it take into account the statistics for each column in the index or just the statistics in the first column (assuming that this table has only index statistics, not column statistics)? If the o

Read More - Register for Free Membership