Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning what is the difference if we create index (at time create table or after insert data into that table ?) RE: what is the difference if we create index (at time create table or after insert data into that table ?)

  • March 27, 2014 at 12:05 am

    #1700552

    +1 Jeff

    Ultimately you need to test and get an idea of when it's quicker. It often does depend on how much data, and your disk I/O. Are you creating a temp table and creating the index afterwards (i.e on the fly) or are you referring to a "typical" table that could have millions of rows over time?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience