Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is Covering Index ?

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


Please Help Members By Posting Answers For Below Questions

What information is maintained within the msdb database?

1016


What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1174


How do you clear a log file?

1106


When would you use it?

1038


Explain indexing and what are the advantages of it?

1067


Can sub report data source be different from that of the parent report?

149


What is the maximum length of an alert name?

1038


What is trigger explain with program?

1013


How to count groups returned with the group by clause in ms sql server?

1137


what is the difference between count(*) and count(1) ?

1123


What is row_number () and partition by in sql server?

1129


How to delete existing triggers using "drop trigger"?

1095


How to find related tables in sql server?

997


How to delete existing rows in a table?

1240


What are the types of stored procedures in an sql server?

1031