Hotsos Home Page

Document Properties

Title: When to Use an Index
Author: Cary Millsap
Get File:
Abstract: For well over a decade, Oracle application developers have used a simple rule of thumb to help them decide whether to use a non-unique index. However, in our field work, we encounter performance problems caused by using the common rule of thumb. This paper identifies the flaws in the common knowledge and helps you improve application performance.
Document type: article
Updated: Thu 26 Feb 2004 (10.1 years ago)
File size: 287,858 bytes
MD5 checksum: c1df94a783c1e27e1729301f82dd0089
File type: .pdf
Authentication: registered — Registered guest (free registration)