Interesting Observation – Index on Index View Used in Similar Query(blog.sqlauthority.com)
submitted by
pinaldave(9662) 2 years, 8 months ago
I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which did not exist in the base table. On careful examination, we found that the query was using the index that was on another view. This was very interesting as I have personally never experienced a scenario like this. In simple words, “Query on the base table can use the index created on the indexed view of the same base table.” read more...
|category: Database
|Views: 62
tags:
SQLAuthority pinaldave SQLServer Database SQL another
Everyones tags:
Your Tags: