Answer Posted / rajesh kumar
An index is used to quickly locate the data record from
which the required data is read. In other words, the index
is only used to locate data records in the table and not to
return data.
A covering index is a special case where the index itself
contains the required data field and can return the data.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain about link server in sql server?
What happens when unicode strings concatenate with non-unicode strings?
What will be query used to get the list of triggers in a database?
Name three of the features managed by the surface area configuration tool? : sql server security
What is report server project?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Which rendering formats are affected by the pagesize properties?
What is dml command?
Can sql server 2016 run on windows 7?
What is data source object?
What is the use of sql profiler in sql server 2012?
What is a schema in ms sql server 2005?
What happens when converting big values to integers?
Difference between report and query parameter. Why do we need different type of parameter?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication