Indexes
The performance of an application is always critical. That's because the productivity of an application user directly relates to the amount of time that the user must sit idle while the application tries to complete work. With database applications, performance depends greatly on how quickly an application can access table data. Typically, disk I/O is the primary performance-determining factor for table access—the less disk I/O that's necessary to access table data, the better the dependent applications will perform. In general, it's best to try to minimize the amount of disk access that applications must perform when working with database tables.
NOTEThis section introduces indexes to support subsequent sections of this book. For complete ...
Get Hands-On Oracle Database 10g Express Edition for Windows 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.
