report optimization

  • Please save the execution plan as .sqlpaln file and attach it.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • And please also post the query.

    Please understand we're not asking for this information to make your life difficult. We're asking because it's very hard to give useful advice around performance issues without having all the information.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • i cant make any attachments .....the comp wont allow me , i actually checked the query in the MSSMS it fast ... it hardly takes like a second to exec , i think the report has got something to do with performance , i know that there is some aggregate functions being used in the report,

    what if i create a new DSV and do those aggregations in there and use the DSV with the report ,

    do you think it should help solving the issue ?

    thanks

    regards

    greg

  • select accountbranchnumber,accountnumber,accounttype,currentbalance,

    postdatedimkey,monthname,condensecodedesc,statementdesc,branchname,accounttypedesc,groupname,

    division from MM_EOMRetail

    where

    accountbranchnumber = 230 and accounttype = 'd'

    order by division, groupname,accountbranchnumber,postdatedimkey

    thanks

    regards

    greg

  • I recommend doing the aggregation in the query, if possible. I'm sure some of the problem is the aggregation.

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply