What is view? why do we have view?

Views can represent a subset of the data contained in a table
　　 Views can join and simplify multiple tables into a single virtual table
　　 Views can act as aggregated tables, where the database engine aggregates data (sum, average etc) and presents the calculated results as part of the data
　　 Views can hide the complexity of data; for example a view could appear as Sales2000 or Sales2001, transparently partitioning the actual underlying table
　　 Views take very little space to store; the database contains only the definition of a view, not a copy of all the data it presents
　　 Depending on the SQL engine used, views can provide extra security
　　 Views can limit the degree of exposure of a table or tables to the outer world

【What is view? why do we have view?】相关文章

1. What is view? why do we have view?

2. Why do we need Unit test

3. Why we need EJB

4. 如何反序的迭代一个序列？how do I iterate over a sequence in reverse order

5. Overload和Override的区别。Overloaded的方法是否可以改变返回值的类型

6. 软件测试LoadRunner面试题：What is the difference between Overlay graph and Correlate graph?

7. 软件测试LoadRunner面试题：If web server, database and Network are all fine where could be the problem?

8. 软件测试LoadRunner面试题：If you want to stop the execution of your script on error, how do you do that?

9. Ado与Ado.net的相同与不同

10. 某/etc/fstab文件中的某行如下： /dev/had5 /mnt/dosdata msdos defaults,usrquota 1 2 请解释其含义

本文来源：https://www.mianshiwenti.com/a13326.html