一些关于MySql加速和优化的笔试题
1. Which will be faster out of these two queries – one with OR or one with IN?
2. Where does MyISAM cache table records?
3. Which will be faster out of queries with explicit INNER JOIN and implicit one?
4. Is InnoDB faster/better than MyISAM?
5. Is CHAR faster than VARCHAR?
6. Is VARCHAR(80) faster than VARCHAR(255)?
7. Are there performance issues when joining tables from different storage engines?
8. If I change a derived table to a view, will performance increase?
9. If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
10. Is it possible to do a FULL OUTER JOIN in MySQL?
【一些关于MySql加速和优化的笔试题】相关文章：
调节和优化MySQL安装的技巧10-31
几个MySql的笔试题01-06
MYSQL基础笔试题01-06
遇到的Mysql的笔试题01-06
Windows系统通用加速优化技巧10-12
Linux数据库的MySQL性能优化技巧09-21
MySQL笔试题目集锦01-06
笔试实例：简单叙述一下MYSQL的优化01-06