Cakephp Developer Interview Questions and Answers

Types of indexes in MySQL, storage engines, query optimization techniques, and EXPLAIN keyword

• Types of indexes in MySQL include primary, unique, and full-text indexes

• Storage engines in MySQL include InnoDB, MyISAM, and MEMORY

• Query optimization techniques include using indexes, optimizing joins, and avoiding unnecessary columns in SELECT queries

• The 'EXPLAIN' keyword in MySQL is used to analyze and optimize queries by showing the query execution plan