Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Do I need those multiple NON UNIQUE indices on my table? RE: Do I need those multiple NON UNIQUE indices on my table?

  • December 7, 2016 at 6:10 am

    #1916489

    Ed Wagner (12/7/2016)

    Oh, and I would create a clustered index on that table. If it were me, I'd use an IDENTITY column.

    I hope this helps.

    Thank you, Ed. Can you advise why would you use clustered index in this case, please? The majority of the data is loaded in big bulks automatically and not processed manually.