{"id":846,"date":"2015-07-30T14:30:31","date_gmt":"2015-07-30T13:30:31","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=846"},"modified":"2015-08-13T12:16:48","modified_gmt":"2015-08-13T11:16:48","slug":"sql-server-interview-question-what-is-a-covered-index","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/sql-server-interview-question-what-is-a-covered-index\/","title":{"rendered":"Sql Server Interview question: What is a covered index?"},"content":{"rendered":"

Question :\u00a0What is a covered index?<\/strong><\/p>\n

A covered index can satisfy a query just by its index keys without having the need to touch any data pages. When an Index covers the query in this way it is a called covering index.<\/p>\n

It means that when a query is fired, SQL Server doesn\u2019t need to go to the table to retrieve the rows, but can produce the results directly from the index as the index covers all the columns used in query.<\/p>\n

Thanks for reading this article,<\/strong><\/p>\n

Next steps :<\/strong><\/p>\n

1. \u00a0 \u00a0<\/strong>Share this with your colleagues because Sharing\u00a0 is Learning<\/strong><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a02.\u00a0\u00a0\u00a0 Comment below if you need any assistance<\/strong><\/p>\n

Powered by CodeReview – Let’s make it Better!<\/a><\/strong><\/em><\/p>\n

Share this:<\/h3>