report optimization

Question

report optimization

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

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

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]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

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

koolme_85 Ten Centuries Points: 1153 More actions · Answer 3

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

koolme_85 Ten Centuries Points: 1153 More actions · Answer 4

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

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

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question