Tuning the Database

Tuning a database includes fine tuning the database server's performance. As a newcomer to SQL, you probably will not be exposed to database tuning unless you are a new DBA or a DBA moving into a relational database environment. Whether you will be managing a database or using SQL in applications or programming, you will benefit from knowing something about the database-tuning process. The key to the success of any database is for all parties to work together as one entity. Some general tips for tuning a database follow:

  • Minimize the overall size required for the database— It's good to allow room for growth when designing a database, but don't go overboard. Don't tie up resources that you may need to accommodate database ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.