Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning so many indexes indexes RE: so many indexes indexes

  • April 18, 2013 at 7:26 am

    #1607733

    Zeal-DBA (4/18/2013)

    thanks for your valuable comment on it.

    But what if client ask to create at least one index on each table which are not even suggested by missing index DMV.

    he needs to show him analysis on the basis i am denying to create unnecessary indexes, any way is there to show him my analysis.

    please advice

    what exactly has the client asked. If he is asking for at least a clustered index on all tables that is a slightly different thing........

    ---------------------------------------------------------------------