Technical Publications

Fourth, evaluate the usage of aggregate queries in your database. Identify columns used in aggregate functions and determine whether the creation of indexes on those columns will improve response time. Finally, identify columns used in ORDER BY statements and make sure there are indexes on those columns. Answers to Selected Problems. 2. ................
................