mysql中的视图

关于mysql视图的文章:

A workaround for the performance problems of TEMPTABLE views

http://www.mysqlperformanceblog.com/2010/05/19/a-workaround-for-the-performance-problems-of-temptable-views/

MySQL VIEW as performance troublemaker

http://www.mysqlperformanceblog.com/2007/08/12/mysql-view-as-performance-troublemaker/

Derived Tables and Views Performance

http://www.mysqlperformanceblog.com/2006/08/31/derived-tables-and-views-performance/

Using VIEW to reduce number of tables used

http://www.mysqlperformanceblog.com/2007/09/28/using-view-to-reduce-number-of-tables-used/

 

(1)视图支持两种算法:MERGE算法和TEMPTABLE算法

(2)MERGE算法支持索引,TEMPTABLE算法不支持索引

(3)MERGE算法会将建立视图的条件和查询视图的条件合并

(4)TEMPTABLE算法会先产生一个临时表,再查询这个临时表,因此不会用到索引

(5)在mysql5.0中,Derived Tables同view有不同的实现,其实应当是相同的实现;Derived Tables被处理按照生成临时表的方式

(6)视图可以用于减少表的数量

阅读更多
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭