tag:blogger.com,1999:blog-5545011210222359771.post3742825211713617055..comments2024-02-28T03:25:40.469-08:00Comments on SQL Server and BI/BA With A Smile: When a Covering Index no longer coversThomas LeBlanchttp://www.blogger.com/profile/02128071506560671112noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5545011210222359771.post-4907561607229043992012-10-22T07:06:00.990-07:002012-10-22T07:06:00.990-07:00Hakim,
Correct. There are 2 issues here. 1. The d...Hakim,<br /><br />Correct. There are 2 issues here. 1. The developers did not know a DBA created a covering index, and 2 the DBA did not know the developer was changing the query.<br /><br />This shows the need for developers and DBAs need to work together and during the testing/QA phase trace the changes in query plans.<br /><br />Thanks,<br />ThomasThomas LeBlanchttps://www.blogger.com/profile/02128071506560671112noreply@blogger.comtag:blogger.com,1999:blog-5545011210222359771.post-11561119077475300662012-10-22T06:49:55.175-07:002012-10-22T06:49:55.175-07:00The change made by the developers to the query eff...The change made by the developers to the query effectively converted the covering index into a "non-covering" index, which by definition would not "cover".Anonymousnoreply@blogger.com