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

Report message to a moderator

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: 21813
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).

Report message to a moderator

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

Report message to a moderator

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: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, as far as I can tell.

Report message to a moderator

Previous Topic: problem with Charts in Reports 6
Next Topic: Report 6i outputs same old report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 11:42:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.