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

  • Thread starter Thread starter pedrorodriguez
  • Start date Start date
Status
Not open for further replies.
P

pedrorodriguez

Guest
Thanks for your answer, I was thinking of creating the index inactive and enable it later, by idxactive or idxbuild, but it is more out of curiosity, if it is a new field, hence with all records with same value, should it be a quick process to activate the index or would it be a long(ish) process? Regards,

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