Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / binyam
A covering index is a non clustered index built upon all the
columns required to satisfy a SQL query without going to the
base table. If a query encounters an index and does not need
to refer to the underlying data table at all, then the index
can be considered a covering index.
To understand a covering index it is very important first
understand non clustered index. a non clustered index does
not affect the order of the data in the table pages,because
the leaf pages of a non clustered index and the data pages
of the table are separate .A pointer is required to navigate
from an index row to the data row. so when a query requests
columns that are not part of the non clustered index chosen
by the optimizer , a lookup is required .The lookup fetches
the corresponding data row from the table by the following
row locator value from the index row, requiring a logical
read on the data page besides the logical read on the index
page. However, if all the columns required by the query are
available in the index itself , them access to the data page
not required then this known as a covering index.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
How to create dbo table in sql server?
When is update_statistics command used?
What are parameterized reports?
Can you name a few encryption mechanisms in sql server?
What is the new security features added in sql server 2016? : sql server security
What is user defined datatypes and when you should go for them?
If no size is defined while creating the database, what size will the database have?
What are data driven subscriptions?
Name few of the dcl commands in sql?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to delete a login name in ms sql server?
What is a matrix in ssrs?
Explain DBCC?
Explain the etl (extraction, transformation, and loading)?
