Mathivanan

• Jul 16th, 2005

 

 
Views are useful for providing a horizontal or vertical subset of data from a table (possibly for security reasons) ; for hiding the complexity of a query; for ensuring that exactly the same SQL is used throughout your application; and in n-tier applications to retrieve supplementary information about an item from a related table.  
 

Shiv Mangal Rahi

• Jul 24th, 2006

 

Hi All,

The advantages of View are under below

1. It reduces the complexiety of Sql Quey.

2. For security purpose. As it doesnt allow you to know about the base tables.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 

The advantages of View are:

security:  only selected column from a table made available to view.

Complaxity: write a complex query and assign this query to a view so next time no need to write that complex query.

Faster:  view refers to a query which is already parsed , so again it does not go to that stage

efficient:  while writing trigger a condition may arise, trigger makes the table in mutating state, so use of views in this sanirio makes it easy.

pratima

• Dec 26th, 2006

 

Hi Rampratap,

U r telling abt the efficiency of view @ mutating table concept. can u pls explain it with an example?

Thanks

Pratima