Performance issue in Impromptu reports 1

[cogjai]

Hi,

We are developing Impromptu reports. Our data base is Oracle 8.1.7 which is of Terabytes size. Our catalogs are designed to retrieve data from views created on database. If we need to get data from 3 or 4 views which in turn will be getting data from 5 or 6 tables, will there be any performance issues? Here i have couple of ideas.

1.Is it advisable to go for one view(which will have all the columns of 3 or 4 views) getting data from all 5 or 6 tables, so that data retrieving will be faster?

2.Is it advisable to create a table (which will have all the columns of 3 or 4 views) and retrieve data, so that it will be faster.

Please let me know if you have any ideas.

thanks in advance

 

[griffindm]

Performance will suffer somewhat, given the number of views and table involved. It may not be major if the views filter or group data based on indexed columns. You may want to investigate materialized views if you encounter performance issues, or even staged reporting tables if the underlying data is static enough.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com