O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

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

Chapter 1: Tuning the Database

In This Chapter

arrow Examining the work to be done

arrow Contemplating physical design considerations

arrow Choosing and clustering indexes

arrow Co-clustering two relations

arrow Indexing on multiple attributes

arrow Tuning indexes, queries, and transactions

arrow Query tuning in a high-concurrency environment

arrow Benchmarking

arrow Keeping user interactions separate from transactions

arrow Holding down traffic between application and server

Creating a precompiled list of frequently used queries

The word tuning ...

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