How long will an index take to create?

Actually - it depends on many things like

  • hardware you use
  • wideness of index
  • current load
  • ...

If index is relatively wide - it can take from minutes to hours.

but

if you have your DB on Enterprise Edition of Sql Server, than you can choose to create an index WITH ONLINE=ON - it will take a little bit more time and space to complete, but will not stop other processing with the table involved


Yes, it depends on a many factors and there's no way to really know unless you try.

I just built an index a single column of type BigInt over 200+ million rows however and it took a hairy 3 minutes.

Sure, my hardware is different from yours, my database version is different from yours etc. etc. but now you have a real world example to give you a ballpark idea rather than somewhere between a picosecond and a googolplex of lifetimes of the Universe.