Forum Post: RE: Cost of creating a new index for a new field in a large table

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
You can add new index as inactive and run idxactivate later. A few millions records is not a large table. If a downtime is exceptable then you can use idxbuild instead of idxactivate. But adding an active index (offline or online) is a bad idea. Regrads, George

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