
Reply to comment
Reply
Click the +1 button below to share it with your friends and colleagues
Share this if you liked it!
Click the +1 button below to share it with your friends and colleagues
t-decoration:none;text-underline:none'>IBM DB2 Certification
LOGOUT
Number of Registered users 714
|
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