1 - 1 of 1
PREVIOUS 1 NEXT
execution plan is same even though it takes 10 times longer to run
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 index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be?Thank you!
View Answer
| Mar 3 2008 5:07 AM GMT
| asked by
Abbi
Execution Plan, Indexes, Performance/Tuning
1 - 1 of 1
PREVIOUS 1 NEXT
