幾個MySql的筆試題

　　Which will be faster out of these two queries – one with OR or one with IN?

　　Where does MyISAM cache table records?

　　Which will be faster out of queries with explicit INNER JOIN and implicit one?

　　Is InnoDB faster/better than MyISAM?

　　Is CHAR faster than VARCHAR?

　　Is VARCHAR(80) faster than VARCHAR(255)?

　　Are there performance issues when joining tables from different storage engines?

　　If I change a derived table to a view, will performance increase?

　　If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?

　　Is it possible to do a FULL OUTER JOIN in MySQL?

【幾個MySql的筆試題】相關(guān)文章：

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

遇到的Mysql的筆試題01-06

mysql有關(guān)權(quán)限的表都有哪幾個01-06

MySQL筆試題目集錦01-06

十一個高級MySql筆試題01-06

360筆試題目07-11

華為2017筆試題08-16

華為2017筆試試題08-10

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