Custom Search
can alter be used to alter views and indexes
Fri, 11/18/2011 - 07:16
Alter command is used to make changes to DB2 objects like table, is it possible to alter a view or an index on a table using the alter command? If the alter command cannot be used to alter views and index then what is the other option of changing existing views and indexes
"; ; ; ;
Click the +1 button below to share it with your friends and colleagues
Share this if you liked it!
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