> On 5/9/07, Ashish Karalkar <ashish.karalkar@xxxxxxxxxxxxxxxxx> wrote: > > Hello All, > Can anybody please point me to Advantages and Disadvantages > of using view Hi Ashish, There are several, but they are generally about implementing a more user friendly database from a well normalised structure. You can use views to do any or all of: act as a filter on fields or records which can be accessed by given users, act as a stored query to avoid writing a commonly used SQL, aggregate normalised tables into a single virtual table, so that access does not require as complex a join, thus it can hide the complexity of the database structure from applications or users. An example use is to have a view which provides only the current version of data from a database which stores multiple versions of the data. Cheers, Brent Wood
