Answers to Selected Questions and Problems

Second, put high-usage end-user tables in their own table spaces. When this is done, the database minimizes conflicts with other tables and maximizes storage utilization. Third, evaluate the creation of indexes based on the access patterns. Identify common search criteria and isolate the most frequently used columns in search conditions. ................
................