O'Reilly logo

Practical SQL Handbook, The: Using SQL Variants, Fourth Edition by Sandra L. Emerson, Marcy Darnovsky, Judith S. Bowman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required