| November 11, 2007 01:17:15 |
#5 |
| srvardhan |
Member Since: November 2007 Total Comments: 1 |
RE: What is view? Types of views?use of views?how to create view(syntax)?
|
The dynamic result of one or more relational operations operating on base relations to produce new relation.
creating view: create view View_Name as select query.
Basically we use views for 1. to reduce the complexity in writing queries --> go with view resolution
2. To improve performance --> go with materializing view (remember if the frequency of executing select query is more than the frequency of updating then only go with this)
Rajavardhan Sarkapally |
| |
