DB2 index



IBM's flagship relational database management system

DB2 index

Postby bparimanik » Fri May 16, 2014 1:01 pm

Hi,

I have an existing program which was reading a table without any index. Later a index was created on the table so can you please advise if the program needs compiling or any runstats and reorg is required further for the program to work efficiently ?
bparimanik
 
Posts: 1
Joined: Fri May 16, 2014 12:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 index

 

Re: DB2 index

Postby dick scherrer » Fri May 16, 2014 7:18 pm

Hello and welcome to the forum,

Suggest you work with your dba to see if this is running efficiently or needs improvement.

One place to look would be to run an EXPLAIN.

Depending on how DB2 intends to service this, recompile, rebind may be necessary.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post