Pages

Saturday, September 7, 2013

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query | Journey to SQL Authority with Pinal Dave

Recently, 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… Continue Reading...

Source: SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query | Journey to SQL Authority with Pinal Dave