DTA report - Statement cost report

Last post 09-23-2008, 6:27 AM by cgdba. 0 replies.
Sort Posts: Previous Next
  •  09-23-2008, 6:27 AM Post number 69674

    • cgdba is not online. Last active: 10-20-2008, 7:56 AM cgdba
    • Not Ranked
    • Joined on 09-23-2008
    • Level 1: Deep thought

    DTA report - Statement cost report

    This is the first time I'm working on DTA. After runningthe workload I got few recommendation for creating new indexes & stats. The statement cost report shows few queries showing good amount of improvement. I don't understand how do I use these queries & improve the performance. Can anyone help me in understanding the statement cost report from DTA & how to implement the recommendations of the same. Thanks
View as RSS news feed in XML