Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Clustered Index

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Clustered Index
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    Post subject:
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    Post subject: Reply to: Clustered Index
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us