Viewing 4 posts - 1 through 5 (of 5 total)
That brings up a whole other issue. Even though when I run it with the index it takes 2 seconds versus 1.25 minutes without the index, the execution plan...
March 3, 2008 at 4:44 pm
WHERE XP.Container_id = @Container_id AND XP.Slot_id = @Slot_id AND XP.IsActive=1
The index contains container_id and slot_id. So it does not cover the IsActive column?
The distinct values are for container_id and...
March 3, 2008 at 1:00 pm
Sorry, please explain what you mean by index 'covering'. Thank you.
March 3, 2008 at 12:21 pm
The table has 232,441 rows with 124,376 distinct values.
March 3, 2008 at 12:20 pm
Viewing 4 posts - 1 through 5 (of 5 total)