| Author: KamalaNathan 04 Nov 2009 | Member Level: Bronze | Rating:  Points: 2 |
View are very useful in real time.
For ex, Normally we will write some of bulk quries to merge 3 0r 4 tables from front end and send to database to retrive the data. If we want to change any condition in quries, we need to open the source code and need to modify the query.
But if we write the same qurey using view, if any changes required in future need to change only on database side. No need to touch the front end part. This is main purpose of going to View.
|
| Author: Sachin Kulkarni 04 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
Views are there say if we need only few columns of a table or tables.
Or the table we use is quite bulky,to reduce load we can use views.
|