© Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova 2021
H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/978-1-4842-6885-8_1

1. Why Optimize?

Henrietta Dombrovskaya1  , Boris Novikov2 and Anna Bailliekova3
(1)
Braviant Holdings, Chicago, IL, USA
(2)
HSE University, Saint Petersburg, Russia
(3)
Zendesk, Madison, WI, USA
 

This chapter covers why optimization is such an important part of database development. You will learn the differences between declarative languages, like SQL, and imperative languages, like Java, which may be more familiar, and how these differences affect programming style. We also demonstrate that optimization applies not only to database queries but also to database design and application architecture. ...

Get PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.