Create a new index

IBM's flagship relational database management system

Create a new index

Postby vegafacundodaniel » Thu Oct 07, 2010 4:06 pm


I have a question please. What is the criteria to create a new index on a db2 table ?

I will have to access to a db2 table using a field that is not key. It is not indexed on.

I'd want to know how I could determinate if I must to create a new index or not to improve the performance for reading.

Thanks in advance !!!
Posts: 61
Joined: Tue Jul 20, 2010 4:27 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Create a new index

Postby NicC » Thu Oct 07, 2010 4:47 pm

see your DBA's - they know your application's data and the DB2 setup.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Create a new index

Postby alexm » Fri Nov 12, 2010 9:26 pm

Index design is part of a database design, and it requires a lot of environmental information. If you're interested to read some basics regarding database design (including a small section related to index design), you might have a look at developerworks "best practice" pages: ... ase+Design

IBM also offers documentation, online and class courses on various levels, etc. etc.

You should find DBAs or database designers in your shop that help you design indexes (and other parts of a database). There might also be tools available in your shop to explain the SQL statements your application performs most often/frequently/heavily, and this information then could be used to discuss with the DBAs and influence the design. :roll:
User avatar
Posts: 35
Joined: Wed Oct 13, 2010 6:40 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Create a new index

Postby GuyC » Thu Nov 18, 2010 5:36 pm

Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2


  • Related topics
    Last post