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
kanmani_karuppannan
Messages: 23
Registered: November 2006
Location: India
Junior Member

Hi

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
JRowbottom
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
Frank
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: Sun Dec 11 03:57:59 CST 2016

Total time taken to generate the page: 0.03966 seconds