Performance
Performance is a critical issue in relational database management systems. Multiuser, production-oriented applications are especially sensitive to performance problems. Databases running on these systems tend to be larger, their operations more complex. The number of users and transactions puts heavy demands on the system, and the tasks for which the applications are responsible are often time critical. However, performance sometimes becomes a matter of concern even for single-user database systems. No one wants to wait an unreasonable length of time for the results of a query or the execution of a data modification statement.
Unfortunately, many aspects of performance are outside the control of users. Instead, people depend on the ...
Get Practical SQL Handbook, The: Using SQL Variants, 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.
