Follow recommended database and query design practices: For best practice design of database components for optimal performance, see Database Design. For best practice design of database queries, see SQL Fundamentals, SQL Request and Transaction Processing, SQL Functions, Operators, Expressions, and Predicates. Set up recommended performance management tools. See About Performance Management Setup. Manage query performance. See “Managing Query Performance” on page 491. Manage the database workload. See “Managing the Database Workload” on page 505. Manage database resources. See “Managing Database Resources to Enhance Performance” on page 515. Do performance-related periodic maintenance. See “Periodic Maintenance and Performance” on page 542.