382: Creating a Context Index; How simple can it get?
Michael Nelson , Northrop Grumman    Biography

Objectives: Reqular indexes result in full table scan on note and free text columns
Oracle Text has Context indexes that are extremely fast
How to build a simple context index and maintain it
Abstract: This presentation will look at what happens when we have a note or comment column in a table and we put an index on it so we can query it faster. It will explain how queries that use this column in the where clause will cause full table scans. It will explain how a context index works. Most of the features that will be covered will be related to the developer and the database designer, but DBA could also benefit from this presentation.

There will be a simple example that shows to build a context index on a note field. It will cover what tables are created after the index is created. To better clarify what is happening we will provided information on how Oracle stores and uses indexes. We will also cover the different types of datastores that are available with context indexes. It will cover how we know that the context index needs to be resynced and if any errors occurred during the indexing process.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Database
Date: Thursday, April 17, 2008
Time: 11:00 AM - 12:00 PM