Home Forums SQL Server 2014 Development - SQL Server 2014 SQL uses 2 different executions plan (slow and fast) for a simple query. Need a new index ? RE: SQL uses 2 different executions plan (slow and fast) for a simple query. Need a new index ?

  • February 23, 2018 at 2:26 pm

    #1981008

    Again, you need to cluster the table on those columns then.  You can adjust nonclus indexes all day and it most often won't do you much good.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.