Need clarification on the index in DB2

l.nethaji · Posted: Thu Aug 19, 2010 1:18 pm

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

GuyC · Posted: Thu Aug 19, 2010 1:32 pm

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.

l.nethaji · Posted: Fri Aug 20, 2010 11:10 am

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.