Utilize and take advantage of Optimizer features in MySQL 8 0 by Amit Bhattachar
Channel: FOSSASIA
Date: 2019-03-22

16 March 2019 15:00, Training Room 2-1

To run your application efficiently on cloud, you would need to make your queries faster. MySQL optimizer over the years have brought in a lot of improvements to handle big queries efficiently and in a faster way. This talk presents you a specific set of features added in MySQL 8.0 that would reduce the execution time of your queries. This session will help you understand tips and tricks that you can use to tune your application. This session would present the following

Cost Model Improvements

Newly added hints

Index Skip-Scan

Internal TempTable Storage Engine