IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Clustered Index


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
l.nethaji

New User


Joined: 16 Mar 2008
Posts: 90
Location: tamil nadu

PostPosted: Thu Aug 19, 2010 1:27 pm
Reply with quote

Hi,

I have some basic db2 understanding

Based on my understanding ,

Clustered index is declared to make the physical ordering in the table .

So when the search is happening in a table for particular value the index table is referred for effecient search.

If the index table is going to be referred for both normal and clustered index ,

What the advantage of having clustered index and what the need for physcial order.

Please let me know if i am wrong .


regards,
L.nethaji
regards,
L.Nethaji
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Aug 19, 2010 1:47 pm
Reply with quote

you need to read some performance and tuning guides.
clustering is interesting when reading (or scanning) more than 1 row via an index.

if you are selecting several rows and they are on the same page or on pages closeby you benefit from these two things :
- usually there are more than 1 row on a page
- pages next to each other can be read in 1 I/O and asynchronously before needing them = prefetching.

clustering helps you avoid I/O's if you put the rows (as much as possible) in the order in which you will mostly process them.
Back to top
View user's profile Send private message
l.nethaji

New User


Joined: 16 Mar 2008
Posts: 90
Location: tamil nadu

PostPosted: Thu Aug 19, 2010 2:48 pm
Reply with quote

Hi ,

Thanks A lot .

I am able to infer the advantages during i/o operation in case of group selection.

Still i am in the process of digging out more into cluster index.


Regards,
L.Nethaji.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Cobol file using index COBOL Programming 2
No new posts DL/I status code AK for GU call using... IMS DB/DC 1
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts choice of clustering index DB2 3
No new posts Secondary index error while loading d... IMS DB/DC 2
Search our Forums:

Back to Top