Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Related Documentation

Conventions

1 Oracle Expression Filter Concepts

1.1 What Is Expression Filter?

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 Concepts of Indexing Expressions

2.2 Indexable Predicates

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 XPath 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

EVALUATE

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 Procedure

ASSIGN_ATTRIBUTE_SET Procedure

BUILD_EXCEPTIONS_TABLE Procedure

CLEAR_EXPRSET_STATS Procedure

COPY_ATTRIBUTE_SET Procedure

CREATE_ATTRIBUTE_SET Procedure

DEFAULT_INDEX_PARAMETERS Procedure

DEFAULT_XPINDEX_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 Procedure

VALIDATE_EXPRESSIONS Procedure

XPINDEX_PARAMETERS Procedure

9 Expression Filter Views

9.1 USER_EXPFIL_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_EXPFIL_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

Index