Interesting Observation – Index on Index View Used in Similar Query

home
database
view story

6 Kicks

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.”

add a comment |category: Database |Views: 62
Tweet