一些MySql加速和優(yōu)化的筆試題

一些關(guān)于MySql加速和優(yōu)化的筆試題

　　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?

【一些關(guān)于MySql加速和優(yōu)化的筆試題】相關(guān)文章：

調(diào)節(jié)和優(yōu)化MySQL安裝的技巧10-31

幾個(gè)MySql的筆試題01-06

MYSQL基礎(chǔ)筆試題01-06

遇到的Mysql的筆試題01-06

Windows系統(tǒng)通用加速優(yōu)化技巧10-12

Linux數(shù)據(jù)庫(kù)的MySQL性能優(yōu)化技巧09-21

MySQL筆試題目集錦01-06

筆試實(shí)例：簡(jiǎn)單敘述一下MYSQL的優(yōu)化01-06

Linux數(shù)據(jù)庫(kù)：關(guān)鍵的MySQL性能優(yōu)化技巧10-11