[progress Communities] [progress Openedge Abl] Forum Post: Re: No-integrity Flag On Big...

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
No-integrity (-i) doesn't mean "no BI notes". While crash recovery is not possible with -i, transaction undo is; so BI notes must still be written. A better practice when adding an index to a very large table is to add it inactive and then activate or build it after the fact. The schema update will then be very quick and will not grow the BI file.

Continue reading...
 
Status
Not open for further replies.
Back
Top