What are best practices to setup Indexes on Heap table on production SQL Server?


  • There are Fragmentations on some of tables on my DB. only two tables are having indexes and others are HEAP

    I want to setup indexes on those HEAP tables and remove fragmentation .

    Can anyone advise, what are best practices and prerequisite to setup indexes on PROD Server.


    Wednesday, June 27, 2018 9:52 AM

All replies