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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
