Okay, then this is freakin' awesome! I have a bunch of single-column indexes that I can drop!
Karen In a message dated 10/31/2012 10:46:25 AM Central Daylight Time, [email protected] writes: > << > 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 > > > >
