一些關于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