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
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?
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?
10. 某/etc/fstab文件中的某行如下: /dev/had5 /mnt/dosdata msdos defaults,usrquota 1 2 请解释其含义
本文来源:https://www.mianshiwenti.com/a13326.html
进入下载页面
上一篇:金蝶的一道SQL笔试题
下一篇:DBA的职责都有哪些
﹝What is view? why do we have view?﹞相关内容
- 软件测试LoadRunner面试题:What is Ramp up? How do you set this
- 软件测试LoadRunner面试题:What is think time? How do you change the threshold?
- 软件测试LoadRunner面试题:What do vuser_init action and vuser_end action contain?
- 软件测试LoadRunner面试题: Where do you set automatic correlation options?
- do you have any Best Practice for testing
- 请解释在new与override的区别
- Weblogc domain问题
- Overload和Override的区别
- override和overload的区别
- 软件测试LoadRunner面试题:What is the difference between standard log and extended log?