Clustered Index.



IBM's flagship relational database management system

Clustered Index.

Postby heshmahesh » Thu Nov 20, 2014 12:23 pm

Hi to all,

I'm a new joinee in a company,
I have done certification in mainframe .

In my office my guide ask me to find some DB2 asnwers.

here is the question ..

what is cluster index?

I know the concept what cluster Index. I explained.

But they are specially asking for which type of table we are using the clustered index??

i can't able to find the answer for this in search.

can anyone knows..?
plz share.


thanks in advance,
Mahesh
heshmahesh
 
Posts: 7
Joined: Mon Nov 10, 2014 5:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Clustered Index.

Postby t1pers » Thu Nov 20, 2014 8:46 pm

It is all up to the application design and how you want to process data. So if you are using clustering index with only one type of tables in other shops they might be using it in different situations. From my point of view you can exclude temporary tables, XML tables and Materialized query tables, so there aren't so much left :D
t1pers
 
Posts: 8
Joined: Mon Feb 11, 2013 1:02 am
Has thanked: 1 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post