- Home
- Search
- Settings
- Top Contributors
- Help Center
What are the advantages and disadvantages of views in a database?
Answer:
Advantages:
•Data isn't dependent on structure of the database.
•Restrict access to a database.
•Subset of data contained in a table.
•Join and simplify multiple tables into a single virtual table.
•Acts as aggregated tables, where aggregated data (sum, average etc.) are calculated and presented as part of the data.
•Gives real time data.
Disadvantages:
•Rows available through a view are not sorted and are not ordered either.
•Cannot use DML operations on a View.
•When table is dropped view becomes inactive, it depends on the table objects.
•It affects performance, querying from view takes more time than directly querying from the table
•Data isn't dependent on structure of the database.
•Restrict access to a database.
•Subset of data contained in a table.
•Join and simplify multiple tables into a single virtual table.
•Acts as aggregated tables, where aggregated data (sum, average etc.) are calculated and presented as part of the data.
•Gives real time data.
Disadvantages:
•Rows available through a view are not sorted and are not ordered either.
•Cannot use DML operations on a View.
•When table is dropped view becomes inactive, it depends on the table objects.
•It affects performance, querying from view takes more time than directly querying from the table
Pratyush7
First answer by ID3418458997.
Last edit by Pratyush7.
Contributor trust: 0
[recommend contributor
recommended].
Question popularity:
3
[recommend question].
