Covering Index versus Clustered Index (Database Index)

Posted by Mestika on Stack Overflow See other posts from Stack Overflow or by Mestika
Published on 2010-05-13T16:50:52Z Indexed on 2010/05/13 16:54 UTC
Read the original article Hit count: 529

Filed under:

covering-index

|

clustered-index

|

db2

|

indexing

|

database

Hi,

I'm working on a database system and it's indexes, but I'm having a really hard time seing the clear difference between a covering index and a clustered index.

I've googled my way around but hasn't got a clear cut answer on:

What is the differences between the two types of indexes
When do I use Covering index and when do I use Clustered index.

I hope someone can explain it to me in a almost children-like answer :-)

Sincerely Mestika

By the way, I'm using IBM DB2 version 9.7

© Stack Overflow or respective owner

Related posts about covering-index

Query doesn't use a covering-index when applicable

as seen on Stack Overflow - Search for 'Stack Overflow'
I've downloaded the employees database and executed some queries for benchmarking purposes. Then I noticed that one query didn't use a covering index, although there was a corresponding index that I created earlier. Only when I added a FORCE INDEX clause to the query, it used a covering index. I've… >>> More
Covering Index versus Clustered Index (Database Index)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm working on a database system and it's indexes, but I'm having a really hard time seing the clear difference between a covering index and a clustered index. I've googled my way around but hasn't got a clear cut answer on: What is the differences between the two types of indexes When do… >>> More
Composite and Covering index

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the diffrence between composite index and covering index in Sql Server ? >>> More
Is there a use scenario we need to create two covering index on the same set of fields in MySQL?

as seen on Stack Overflow - Search for 'Stack Overflow'
When will the below be necessary: create index i_t_a_b on t(a,b); create index i_t_b_a on t(b,a); >>> More
Does compound index have direction in MySQL?

as seen on Stack Overflow - Search for 'Stack Overflow'
When will the below be necessary: create index i_t_a_b on t(a,b); create index i_t_b_a on t(b,a); >>> More

Related posts about clustered-index

Changing an MSSQL clustered index field from containing "random" GUIDs to sequential GUIDs - how wil

as seen on Server Fault - Search for 'Server Fault'
We have an MSSQL database in which all the primary keys are GUIDs (uniqueidentifiers). The GUIDs are produced on the client (in C#), and we are considering changing the client to generate sequential (comb) GUIDs instead of just using Guid.NewGuid(), to improve db performance. If we do this, how will… >>> More
SQL Server database with clustered GUID PKs - switch clustered index or switch to sequential (comb)

as seen on Stack Overflow - Search for 'Stack Overflow'
We have a database in which all the PKs are GUIDs, and most of the PKs are also the clustered index for the table. We know that this is bad (due to the random nature of GUIDs). So, it seems there are basically two options here (short of throwing out GUIDs as PKs altogether, which we cannot do (at… >>> More
MS SQL Database with clustered GUID PKs - switch clustered index or switch to sequential (comb) GUID

as seen on Stack Overflow - Search for 'Stack Overflow'
We have a database in which all the PKs are GUIDs, and most of the PKs are also the clustered index for the table. We know that this is bad (due to the random nature of GUIDs). So, it seems there are basically two options here (short of throwing out GUIDs as PKs altogether, which we cannot do (at… >>> More
SQL Server Clustered Index: (Physical) Data Page Order

as seen on Stack Overflow - Search for 'Stack Overflow'
I am struggling understanding what a clustered index in SQL Server 2005 is. I read the MSDN article Clustered Index Structures (among other things) but I am still unsure if I understand it correctly. The (main) question is: what happens if I insert a row (with a "low" key) into a table with a clustered… >>> More
Beware Sneaky Reads with Unique Indexes

as seen on SQL Blog - Search for 'SQL Blog'
A few days ago, Sandra Mueller (twitter | blog) asked a question using twitter’s #sqlhelp hash tag: “Might SQL Server retrieve (out-of-row) LOB data from a table, even if the column isn’t referenced in the query?” Leaving aside trivial cases (like selecting a computed column that does reference… >>> More