Contents

List of Examples

List of Figures

List of Tables

Title a nd Copyright Information

Send Us Your Comment s

Preface

Audience

Documentation Accessibility

Related Documentation

Conventions

1 Oracle Expression Filter Concepts

1.1 What Is Expression Filter?

< dl>

1.1.1 Expression Filter Usage Scenarios

1.2 Introduction to Expressions

1.2.1 Defining Attribute Sets

1.2.2 Defining Expression Columns

1.2.3 Inserting, Updating, and Deleting Expressions

1.3 Applying the SQL EVALUATE Operator

1.4 Evaluation Semantics

1.5 Granting and Revoking Privileges

1.6 Error Messages

2 Indexing Expressions

2.1 Co ncepts of Indexing Expressions

2.2 Indexable Predica tes

2.3 Index Representation

2.4 Index Processing

2.5 Predicate Table Query

2.6 Index Creation and Tuning

2.7 Index Usage

2.8 Index Storage and Maintenance

3 Expressions with XPat h Predicates

3.1 Using XPath Predicates in Expressions

3.2 Indexing XPath Predicates

3.2.1 Indexable XPath Predicates

3.2.2 Index Representation

3.2.3 Index Processing

3.2.4 Index Tuning for XPath Predicates

4 Expression Filter Internal Objects

4.1 Attribute Set Object Type

4.2 Expression Validation Trigger

4.3 Expression Filter Index Objects

4.4 Expression Filter System Triggers

5 Using Expression Filter with Utilities

5.1 Bulk Loading of Expression Data

5.2 Exporting and Importing Tables, Users, and Databases

5 .2.1 Exporting and Importing Tables Containing Expression Columns

5.2.2 Exporting a User Owning Attribute Sets

5.2.3 Exporting a Database Containing Attribute Sets

6 SQL Operators and Statements

E VALUATE

ALTER INDEX REBUILD

ALTER INDEX RENAME TO

CREATE INDEX

DROP INDEX

7 Object Types

EXF$ATTRIBUTE

EXF$ATTRIBUTE_LIST

EXF$INDEXOPER

EXF$TABLE_ALIAS

EXF$ XPATH_TAG

EXF$XPATH_TAGS

8 Management Procedures Using the DBMS_EXPFIL Package

ADD_ELEMENTARY_ATTRIBUTE Procedure

ADD_FUNCTIONS Pro cedure

ASSIGN_ATTRIBUTE_SET Procedure

BUI LD_EXCEPTIONS_TABLE Procedure

CLEAR_EXPRSET_STATS Procedure

COPY_ATTRIBUTE_SET Procedure

CREATE_ATTRIBUTE_SET Procedure

DEFAULT_INDEX_PARAMETERS Procedure

DEFAULT_XPINDE X_PARAMETERS Procedure

DEFRAG_INDEX Procedure

DROP_ATTRIBUTE_SET Procedure

GET_EXPRSET_STATS Procedure

GRANT_PRIVILEGE Procedure

INDEX_PARAMETERS Procedure

REVOKE_PRIVILEGE Procedure

UNASSIGN_ATTRIBUTE_SET Proc edure

VALIDATE_EXPRESSIONS Procedure

XPIN DEX_PARAMETERS Procedure

9 Expression Filter Views

9.1 USER_EXPFI L_ASET_FUNCTIONS View

9.2 USER_EXPFIL_ATTRIBUTES View

9.3 USER_EXPFIL_ATTRIBUTE_SETS View

9.4 USER_EXPFIL_DEF_INDEX_PARAMS View

9.5 USER_EXPFIL_EXPRESSION_SETS View

9.6 USER_EXP FIL_EXPRSET_STATS View

9.7 USER_EXPFIL_INDEX_PARAMS View

9.8 USER_EXPFIL_INDEXES View

9.9 USER_EXPFIL_PREDTAB_ATTRIBUTES View

9.10 USER_EXPFIL_PRIVILEGES View

A Managing Expressions Defined on One or More Database Tables

B Application Examples

C Installing Oracle Expression Filter< /a>

Index