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
 

 

Need clarification on the index in DB2

 
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:18 pm    Post subject: Need clarification on the index in DB2
Reply with quote

Hi,

I have some clarification on the index in DB2.

If i have a table t1 which has 3 column empl id ,salary and location.


If i create a unique index on the emp id .

I will have a ordered set of emp id values which is stored in the index tablespace .

If i try to search some emp id say 25 in the t1 table .

What type of search the db2 system follows in order to find the records .

Is the search is based on the index we declare on the column in the table.

Please let me know if have any links which give more information on this .

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

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Thu Aug 19, 2010 1:32 pm    Post subject:
Reply with quote

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/c0005300.htm
is for LUW but the idea is the same.
Back to top
View user's profile Send private message
l.nethaji

New User


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

PostPosted: Fri Aug 20, 2010 11:10 am    Post subject: Reply to: Need clarification on the index in DB2
Reply with quote

Hi,

I just read the link . Its nice but do you have some practical examples

of searching ,inserting and deleting .

I tried in the search engine every thing i got is so theoretical.

If you have any, could you please share with me .

Thanks ,
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 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
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm
No new posts Need clarification of VSAM FCT and DF... pkmurali CICS 15 Sun Apr 10, 2016 1:06 am


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