Ultimate Optimization Algorithm
Henrietta Dombrovskaya, Boris Asenovich Novikov, Anna Bailliekova · Apress eBooks · 2021
The preceding chapters covered a lot of optimization techniques: not only different ways to optimize SQL statements but also how database design affects performance, the importance of working together with application developers, the use of functions, and many other aspects of database performance. This chapter organizes these techniques into a set of guidelines providing a systematic way to develop efficient declarative queries and/or tune/optimize them, as well as choose the right database design.