Optimizing Queries
When you submit a SQL statement to the database management system, a lot of work that you don't see gets done. In fact, SQL is considered a nonprocedural language precisely because it does not require the user to specify the steps the system must take to execute the command. Instead, the user simply states what is being sought.
The strength of the nonprocedural approach is the same as its drawback. To state it positively, the system does the work for you. The bad news is that once you're committed to a particular database design, you usually have no choice but to trust the system's intelligence rather than your own.
Optimizers
The part of the database management system responsible for analyzing a SQL statement is called the ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.
