Home » SQL & PL/SQL » SQL & PL/SQL » Adv of view
Adv of view [message #218654] Fri, 09 February 2007 03:30 Go to next message
Messages: 23
Registered: November 2006
Location: India
Junior Member


I heart that

The advantages to using views is:

"Network traffic is minimized because all foreign keys are
denormalized on the server"

How n/w traffic is reduced while using a view?

please advice.

Re: Adv of view [message #218662 is a reply to message #218654] Fri, 09 February 2007 03:59 Go to previous messageGo to next message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
That sounds like nonsense to me.
I wouldn't anticipate a view affecting the network traffic at all.
Re: Adv of view [message #218664 is a reply to message #218662] Fri, 09 February 2007 04:10 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
I agree with JRowbottom.
It all depends on what you compare it with: the same query not using a view (no difference) or separate queries for master tables and detail tables (WILL give a difference, but is plain stupid)
Previous Topic: Timestamp problem
Next Topic: CTL File input parameters
Goto Forum:

Current Time: Fri Oct 21 21:24:44 CDT 2016

Total time taken to generate the page: 0.13748 seconds