GeekInterview.com
Series: Subject: Topic:
Question: 18 of 118

Covering Indexes

List down the advantage and disadvantages of Covering indexes.
Asked by: psingla | Member Since Mar-2010 | Asked on: Mar 9th, 2010

View all questions by psingla   View all answers by psingla

Showing Answers 1 - 1 of 1 Answers
Lokesh M

Answered On : Dec 12th, 2011

View all questions by Lokesh M   View all answers by Lokesh M

Covering Indexes are useful for Input / Output intensive workloads.
Covering indexes are smaller in size
Covering Indexes are sorted by values
It is easier to cache date in Covering Indexes

Covering Indexes cannot be used to select all the columns / entire table.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Btrieve

Clipper

Database Admin

Firebird

Informix

Microsoft Access

MYSQL

PostgreSQL

Progress

SAP DB

SQL

SQL Server

Stored Procedures

Sybase

Teradata

Unify

Interview Coaching

How do you handle pressure and stress?

Tell me three things about you, which are not found in your resume

What are the things you wish to achieve in 5 years?

What will you do when you are not able to get your message across to your audience?

Provide an example of a goal that you successfully attained.

What do you do when someone criticizes you?

Careers and Higher Education Options for BBA Graduates

What are the career options available in Software Testing Industry?

Describe a time when you had to work under pressure.

Career Options for BCA Graduates

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe