Reply to comment

Yes Alter Index and Alter View are possible.

Alter Index Indexname

Bufferpool BP0/BP1/BP2

close yes/no

FREEPAGE qty PCTFREE qty

Using STOGROUP stogroupname

PRIQTY amount SECQTY ammount

ERASE YES/NO

will do the job for alter index

ALTER VIEW viewname REGENERATE will do the job

or DROP and CREATE the view will go fine.

 

Thanks,

Raja L