Jump to main menu Jump to toolbar navigation Jump to main content
UNI home page

ITS - Information Systems

MyUNIverse | WebCT | Calendar | A-Z Index | E-Mail | Contact UNI | Directory | Search

 

ITS-IS Home
Director of Information Systems
Student Information Systems
Financial Information Systems
Database & Application Admin
Data Access

 

Meet the Staff
FAQ
Forms
MEMFIS
Current Projects
System Responsibilities

 

 ITS-IS News
March 26, 2007
Collab Status Updates

 

October 25, 2006
Parent Portal allows access to student reports

 

 

 

  

 

Oracle Indexing Standards

 

In order to obtain the best database performance with minimal tuning we have defined some standard indexes which should be created by every application developer as they develop new database tables.

  1. Primary Keys:
    All our new databases should be using referential integrity, and as a result all Primary keys will have a unique key implicitly created when the primary key is created, so you should NOT have to create an index here manually.
  2. Foreign Keys:
    Each foreign key should have its own non unique b-tree index created to support it. This will ensure that 95+% of queries and joins have sufficient indexes to avoid most table scans.
Should you find your performance still lacking or if table scans are being performed (by doing an explain plan) please contact one of the DBA's for a code review. We will determine if any additional indexing is warranted.
 
Maintained by Information Technology Services - Information Systems
Last Updated: Friday, 03-Aug-2007 13:58:48 CDT
Copyright © University of Northern Iowa, Cedar Falls, Iowa. All rights reserved.
Privacy Statement | Policies & Procedures