Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Database Engine Tuning Advisor RE: Database Engine Tuning Advisor

  • June 13, 2013 at 6:15 am

    #1623652

    basavarajyn (6/13/2013)

    Hi,

    When I ran Database Engine Tuning Advisor, it suggests to create a non-clustered index on the column where a clustered index is already present.

    Can somebody give me some explanation why it is saying like that?

    Regards,

    Basavaraj Yn

    Is that column the only column in the Clustered index, if not, is it the leading column?