|Oracle 8i Data Cartridge Developer's Guide
Release 2 (8.1.6)
Part Number A76937-01
SBTREE: An Example of Extensible Indexing, 8 of 8
One typical usage scenario is described below. Create a table and populate it.
CREATE TABLE t1 (f1 number, f2 VARCHAR2(200)); INSERT INTO t1 VALUES (1, 'adam'); insert into t1 VALUES (3, 'joe');
sbtree index on column f2. The create index statement specifies the indextype to be used.
Execute a query that uses one of the
sbtree operators. The explain plan output for the same shows that the domain index is being used to efficiently evaluate the query.