<< Here's why this interests me. At this client, we have an index on ShipDate by itself because we often query just by that date. However, we also have a multi-column index on ShipDate / Shipper because we often query on those 2. The index ShipDate alone would be unnecessary if we could do a multi-column instead and have it work even if you only query on the first column. >>
If your index is on TableName(ShipDate, Shipper)then you do not need a separate index on TableName(ShipDate)-- you already have one. -- Larry
