Will alter index adding a column effect the application

satyender · Posted: Thu Aug 21, 2008 3:22 am

Hi all,

If I alter index adding a column,would it effect the application programs.
Do they need to be recompiled again.

Please suggest me.

** If my question is not appropriate pls excuse me **

dick scherrer · Posted: Thu Aug 21, 2008 3:30 am

Hello,

It will help if you post what you "had" and how it was changed - both the data column(s) and the index definition(s).

dbzTHEdinosauer · Posted: Thu Aug 21, 2008 9:49 am

If you are only adding a column to the index, I would suggest rebinding inorder to take advantage of the 'new' index.
The DBRM will not have changed - unless you change the SQL, so no need to reprecompile and recompile.