slow report with view, will a SP speed it up?

[staceyz]

Hello, I have a pretty intensive query for a certain report that is run about once a week. So far, I've built a view and then I have 3 queries in my report [Oracle Reports version 2.5]. The Oracle database is version 7.3.4.

The view takes about 3 minutes to run, so the report then takes about 1 hour per page to run. [At least it's not more than 2 pages!]

Will using a stored procedure help performance? I am new to Oracle Reports and find it very confusing. I have no idea how to use a stored procedure in a report. Any help would be appreciated!

 

[MikeJones]

Is the report ad hoc or canned to run every morning? If its the later you could you pregenerate a table on the DB with the select you currently have in your report and then just do a select * from this