Need to add a new Index - compile or rebind?

Post by **Sulabh Sinha** » Sat Sep 14, 2013 7:58 pm

Hi,

For an existing DB2 Table of zOS, if we add a new index would it require to compile or rebind the existing programs?

Regards,
Sulabh

Post by **Anuj Dhawan** » Sat Oct 19, 2013 4:04 pm

Unless I'm mistaken - you'd need both. If the index column is not used in any SELECT for a given program, you'd bind it get the proper access path, fwiw.

Post by **Sulabh Sinha** » Fri Jun 20, 2014 4:38 pm

Ok, thanks Anuj.

Post by **enrico-sorichetti** » Fri Jun 20, 2014 5:35 pm

adding an index is transparent to the application program...

a rebind is more than enough

Post by **Sulabh Sinha** » Fri Jun 20, 2014 10:28 pm

I'm not sure enrico-sorichetti if I followed you, could you please restate that again.

Post by **enrico-sorichetti** » Sat Jun 21, 2014 6:51 pm

adding an index is transparent to the application program...
restated how requested

quick and dirty explanation ...

when issuing a select on a table without indexes DB2 must do a FULL table scan to find out the rows
which satisfy the where condition of the select

if an index is defined on the relevant columns a FULL table scan is no longer needed ( generally )

so the APPLICATION PROGRAM is not aware of the optimisations implemented by the support group

to take advantage of the new performance option ( the index ) a bind is required

Mainframe, MVS and zOS Discussion

Need to add a new Index - compile or rebind?

Need to add a new Index - compile or rebind?

Re: Need to add a new Index - compile or rebind?

Re: Need to add a new Index - compile or rebind?

Re: Need to add a new Index - compile or rebind?

Re: Need to add a new Index - compile or rebind?

Re: Need to add a new Index - compile or rebind?

Create an account or sign in to join the discussion

Create an account

Sign in