Selects from a domain index.
This operation is implemented in the following versions
|
This example demonstrates a DOMAIN INDEX operation on a Oracle Text index. In Oracle 9.2, Oracle Text is installed by DBCA. Alternatively it can be installed manually by running the $ORACLE_HOME/ctx/admin/dr0inst.sql script
This example was developed using Oracle 9.2.0.1 on Windows 2000
This example requires the following table and index definitions
CREATE TABLE t1
(
c1 NUMBER PRIMARY KEY,
c2 VARCHAR2(30)
);
INSERT INTO t1 VALUES (1,'One');
INSERT INTO t1 VALUES (2,'Two');
INSERT INTO t1 VALUES (3,'Three');
COMMIT;
CREATE INDEX i1 ON t1 (c2)
INDEXTYPE IS CTXSYS.CONTEXT;
The table does not need to be analysed
The statement
SELECT c1
FROM t1
WHERE CONTAINS (c2,'Two') > 0;
generates the following execution plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 TABLE ACCESS (BY INDEX ROWID) OF 'T1' 2 1 DOMAIN INDEX OF 'I1'