The table that has the added index is called within a function that is being called by the stored procedure. I wonder if this is the problem? The...
Yes, I agree. I just started working here on Friday as a consultant and asked the very same question. The reason explained to me was the table is a...
The table has 232,441 rows. The number of distinct values for the index is 123,476. It is SQL Server 2005.
I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity...
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the...
Separate names with a comma.
