Page 1 of 1

DB2 index

PostPosted: Fri May 16, 2014 1:01 pm
by bparimanik
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 ?

Re: DB2 index

PostPosted: Fri May 16, 2014 7:18 pm
by dick scherrer
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.