Hi, I have a report which is running more than an hour while refreshing,then how do we improve report performance without doing any chnages in reports level (We can do it in Universe level & DB level)
Thanks Lokesh
lokesh120183 (BOB member since 2009-11-17)
Have you analysed the query and applied indexes?
Mak 1 (BOB member since 2005-01-06)
What type of database are you working with, both in terms of OLTP or data warehouse and in terms of Oracle 10g, SQL Server 2005, etc.
Have a chat with your DBA.
Universe best practices.
Jansi (BOB member since 2008-05-12)
(BOB member since 2005-01-06)
(BOB member since 2008-05-12)