O'Reilly logo

Effective SQL: 61 Specific Ways to Write Better SQL, First Edition by Ben G. Clothier, Douglas J. Steele, John L. Viescas

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

2. Programmability and Index Design

You cannot assume that merely having a good logical data model design will allow you to write effective SQL. You must ensure that your design is physically implemented in an appropriate manner, or you may find that your ability to extract meaningful information from the data in an efficient manner using SQL will be compromised.

One of the key elements to ensure that your SQL queries perform well is proper indexing of the tables. The items in this chapter help you understand some of the often-overlooked considerations when implementing your correctly designed data model. Although creation of the tables and indexes is often left to database administrators (DBAs), it turns out that indexing is probably best done ...

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