Advantages: view is used to retrieve the data very fastly from the database tables
- memory wastage is reduced
- faster than joins to retrieve the data from database tables
Disadvantages:
- view is not a container,it will not hold the data
- view memory is not permanent memory