A Guide to Oracle9i. 2. Lesson A Objectives. Learn how to create and use indexesBecome familiar with PL/SQL stored program unitsLearn how to create server-side stored program units in SQL*PlusLearn how to use Forms Builder to create stored program units. A Guide to Oracle9i. 3. Database Indexes.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
1. A Guide to Oracle9i 1 Advanced SQL And PL/SQL Topics Chapter 9
2. A Guide to Oracle9i 2 Lesson A Objectives Learn how to create and use indexes
Become familiar with PL/SQL stored program units
Learn how to create server-side stored program units in SQL*Plus
Learn how to use Forms Builder to create stored program units
3. A Guide to Oracle9i 3 Database Indexes Similar to an index in a book
Table with list of sorted data values and corresponding physical location
Used to speed searches
Uses ROWID column to represent physical location
Primary key indexed automatically
Unlimited number allowed, but more indexes means more processing time for action queries (insert, update, delete)
4. A Guide to Oracle9i 4 Creating an Index Create index after table data is loaded CREATE INDEX index_name ON tablename (index_fieldname); Convention for naming index: tablename_fieldname.