O'Reilly logo

Building Scalable and High-Performance Java™ Web Applications Using J2EE™ Technology by Greg Barish

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

Query Processing

Although I've reviewed the basics of SQL, I haven't yet addressed how the database interprets SQL and how results are gathered. The overall process for resolving a SQL query is known as query processing. It's a topic that has been and continues to be a major focus of database research because of its impact on performance.

As I mentioned earlier, SQL is declarative. Although it provides a language for questions to be asked, it doesn't specify how those questions should be answered. There's no standard. Instead, each vendor has its own strategy. Understanding the details of query processing can provide you with great leverage in tuning database performance. In this section, I provide a simple overview along with an example to give ...

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