8. Performant SQL
Overview
In this chapter, you will learn how to optimize a database to allow queries to be executed with fewer resources. First, you will look at how a database engine performs basic queries by developing your understanding of sequential scans. After that, you will look at optimizing SELECT queries by creating indexes on database tables, which improve performance. You will also learn about tools and techniques for terminating inefficient queries that are consuming your database resources. After all this, you will explore advanced functionalities by creating custom functions for special computations and examine how to apply custom constraints to your database by using triggers.
Introduction
In Chapter 7, Analytics Using ...
Get SQL for Data Analytics - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
