Tag: queries

Optimizing MySQL: Queries and Indexes Article 3 of 4

Optimizing MySQL: Queries and Indexes Article 3 of 4Courtesy of: Ian Gilfillan Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example our employee table consists of thousands of people from Swaziland, and with the surname “Dlamini”. So we need to index on…

Optimizing MySQL: Queries and Indexes Article 1 of 4

Summary This series of four articles will demonstrate how to optimize your MySQL Databases. These articles have been provided courtesy of Ian Gilfillan Optimizing MySQL: Queries and Indexes – Page 1 More on Indexes – Page 2 Leftmost Prefixing – Page 3 Optimizing Inserts – Page 4 Optimizing MySQL: Queries and Indexes Article 1 of…