Home Forums SQL Server 2008 SQL Server 2008 - General query tuning (PFA, execution plan and indexed view)- need help to enhance performance RE: query tuning (PFA, execution plan and indexed view)- need help to enhance performance

  • saxena200 (2/5/2013)


    hahahaha.... at the end you have to trust DTA

    well, inner query is not helping at all, Not getting any concrete solution for tuning this....

    execution plan is not showing anything extremely costly i am confused

    :w00t::w00t::w00t:

    No, no you don't. Anything that DTA provides should be thoroughly tested before it is implemented in a production environment.

    Been there, done that.