Drill Down vs Drill Through Performance

[kgcognos]

Anyone have any issues with performance using drill down and drill through? Are there any differences with performance when using hierarchy vs regular table?

When I add sub totals/Grand total in my drill though the performance is very slow. Any tips to make it faster?

Thank you in advance. 

[Francis aka khayman]

drill down is possible only if you have DMR/dimensions

[MFGF]

When I add sub totals/Grand total in my drill though the performance is very slow. Any tips to make it faster?

Are you using a relational or dimensional package? What technique are you using to add the totals?

MF.

[kgcognos]

Relational.  Any difference in performance if dimensional package is used?
I'm just doing regular Total function. I have 3 subtotals and the Grand Total. If remove this, my report runs fast. I need the subtotals. Please help!!

[kgcognos]

Please help with subtotals. We are using relational and performance is so slow when there is a subtotals/grandtotal on the report.
Any suggestions how to improve the performance?

[bdbits]

There is no silver bullet. There are many factors that go into performance, particularly relational. They include how well it was modeled, queries involved, volume of data (number of rows), how the database is configured and tuned, etc.

Post the generated SQL if you can, we might be able to spot something. I would also paste and run the generated SQL into your database's standard client (e.g. SQL Server Management Studio, or PLSQL Developer, or similar tools). Run it there and check the performance, and generate an explain plan and review it. If you have access to DBAs, they may be able to help.