ryder
Uploaded by
52 SLIDES
668 VUES
520LIKES

Mastering Indexes and PL/SQL in Oracle 9i: Advanced Techniques

DESCRIPTION

This guide covers advanced topics in Oracle 9i, focusing on the creation and usage of indexes and PL/SQL stored program units. Learn how to effectively create server-side stored program units in SQL*Plus and utilize Forms Builder for programming. Understand the role of database indexes, their impact on query performance, and the conventions for naming indices. With practical examples and clear explanations, this resource is essential for database professionals looking to enhance their skills in Oracle 9i.

1 / 52

Télécharger la présentation

Mastering Indexes and PL/SQL in Oracle 9i: Advanced Techniques

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

Playing audio...

    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.

More Related