1 视图
https://www.cnblogs.com/chenpi/p/5133648.html
2 索引
https://www.cnblogs.com/zhaobingqing/p/7066112.html
https://www.cnblogs.com/shijianchuzhenzhi/p/6383117.html
https://www.cnblogs.com/chenshishuo/p/5030029.html
http://liucw.cn/2018/01/07/mysql/%E7%B4%A2%E5%BC%95%E4%BC%98%E5%8C%96%E5%88%86%E6%9E%90/
3 存储过程
http://blog.csdn.net/a__yes/article/details/52795793
4 触发器