what is Covering Index ?

Answer Posted / midhu

- Index covering means that "Data can be found only using indexes, without touching the tables"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is master database? : SQL Server Architecture

539


What is acid properties?

603


Tell me about pre-defined functions of sql?

700


can you instantiate a com object by using t-sql? : Sql server database administration

528


Does partitioning help performance?

536






List the different types of joins?

574


how can a database be repaired? : Sql server administration

526


What is function of master database?

94


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1340


How to update a field in SQL after ALTERING a row?

699


What is a fill factor?

635


What are different types of data sources?

498


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

582


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

658


what purpose does the model database serve? : Sql server database administration

517