Home » SQL & PL/SQL » SQL & PL/SQL » Does Selecting From Views Affect Performance?
Does Selecting From Views Affect Performance? [message #366324] Fri, 12 December 2008 16:48 Go to next message
Andre1
Messages: 4
Registered: November 2008
Location: London
Junior Member
As far as performance is concerned, is it better to write one large query which refers to tables directly, or to break down this potentially complex query into smaller ones, i.e. Views, and then pull them all together in a simpler query which selects from those Views?
Re: Does Selecting From Views Affect Performance? [message #366330 is a reply to message #366324] Fri, 12 December 2008 17:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1291563605946
Re: Does Selecting From Views Affect Performance? [message #366376 is a reply to message #366330] Sat, 13 December 2008 02:42 Go to previous message
Andre1
Messages: 4
Registered: November 2008
Location: London
Junior Member
Many thanks for the useful link Smile
Previous Topic: case work in 8.1.7 or not ? (Im getting an error)
Next Topic: where condition | how to form the condition?
Goto Forum:
  


Current Time: Fri Dec 02 12:26:38 CST 2016

Total time taken to generate the page: 0.05402 seconds