Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous
Yes Alter Index and Alter

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

Reply

  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 714
Theme by Dr. Radut.