Home » Developer & Programmer » Reports & Discoverer » Using Views in Report10g
Using Views in Report10g [message #270280] Wed, 26 September 2007 06:52 Go to next message
brintha
Messages: 28
Registered: August 2007
Junior Member
Hi,
Can any one help me whether the performance of report will be affected if we use views in reports?

thanks,
brintha

Re: Using Views in Report10g [message #270295 is a reply to message #270280] Wed, 26 September 2007 07:41 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Theoretically, no (if a view is properly created, all underlying tables properly indexed etc.). From my experience, yes - sometimes significantly. But that might be because of lousy CREATE VIEW statement (which I wasn't allowed to change).
Re: Using Views in Report10g [message #270350 is a reply to message #270295] Wed, 26 September 2007 10:42 Go to previous messageGo to next message
brintha
Messages: 28
Registered: August 2007
Junior Member
Hai,
Littlefoot, thanks for your reply. What about in line views? Will they affect the performance in report builder.

regards,
brintha
Re: Using Views in Report10g [message #270402 is a reply to message #270350] Wed, 26 September 2007 15:16 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, as far as I can tell.
Previous Topic: problem with Charts in Reports 6
Next Topic: Report 6i outputs same old report
Goto Forum:
  


Current Time: Sat Dec 03 18:01:41 CST 2016

Total time taken to generate the page: 0.10708 seconds