Index

A B C D E F G H I J K L M N O P Q R S T U V W X Z

A

ABOUT query, 4.2.1

adding for your language, 9.4.1

case-sensitivity, 4.1.8.2

definition, 4.1.6

accents

indexing characters with, 3.2.8.2

ACCUM operator, 4.2.2

ADD_STOPCLASS procedure, 3.3.4.3

ADD_STOPTHEME procedure, 3.3.4.3, 3.3.4.3

ADD_STOPWORD procedure, 3.3.4, 3.3.4.3

ADD_SUB_LEXER procedure

example, 3.3.2.5

administration tool, 10.6

ALTER INDEX statement

rebuilding index, 3.4.4

resuming failed index, 3.4.3

alternate spelling, 3.2.8.3

alternative grammar, 4.1.18

alternative scoring, 4.1.17

AND operator, 4.2.2

application

sample, A, B

applications, updating, 11

attribute

searching XML, 8.3.2

attribute sections, 8.1.2.5

AUTO_FILTER filter, 3.1.3.2, 3.2.2, 3.2.4, 7.8.4

AUTO_SECTION_GROUP object, 8.1.1.1

automatic sections, 8.3.1

B

background DML, 10.5

base-letter conversion, 3.2.8.2

BASIC_LEXER, 3.2.5

BASIC_SECTION_GROUP object, 8.1.1.1

BFILE column, 3.2.1.1

indexing, 3.3.6.2

BINARY format column value, 3.2.2.2

BLOB column, 3.2.1.1

indexing, 3.3.6.2

blocking operations

tuning queries with, 7.6

bypassing rows, 3.2.3

C

cantaloupe dispenser, A.1

case-sensitive

ABOUT query, 4.1.8.2

indexing, 3.2.7

queries, 4.1.8

thesaurus, 9.1.2

catalog application, 2.4

example, 2.4

CATSEARCH, 4.1.2

creating index for, 3.3.7.3

operators, 4.3

SQL example, 4.1.2.1

structured query, 4.1.2.1

CATSEARCH queries, 2.4

CHAR column, 3.2.1.1

Character Large Object (CLOB), 2.3

character set

indexing, 3.2.4

indexing mixed, 3.2.4.1

character set column, 3.2.1.6

charset column, 3.2.4.1

CHARSET_FILTER, 3.1.3.2, 3.2.4

Chinese indexing, 3.2.8.5

CHINESE_VGRAM_LEXER, 3.2.8.5

classification

Decision Tree (supervised), 6.4.1

rule-based, 6.3

simple, see rule-based classification

supervised, 6.4

SVM (supervised), 6.4.2

unsupervised

classification application

example, 2.5

CLOB (Character Large Object) datatype, 2.3

CLOB column, 3.2.1.1

indexing, 3.3.6.2

clustering, see unsupervised classification

column types

supported for indexing, 3.2.1.1

composite words

indexing, 3.2.8.4

concordance, 5.1.3.3

CONTAINS

operators, 4.2

PL/SQL example, 4.1.1.2

query, 4.1.1

SQL example, 4.1.1.1

structured query, 4.1.1.3

CONTAINS query, 2.3

CONTEXT grammar, 4.2

CONTEXT index

about, 3.1.1

creating, 3.3.1, 3.3.6

HTML example, 2.3, 3.3.6.3, A.2.2

couch, self-tipping, A.1

counting hits, 4.2.10

CREATE INDEX statement, 3.3.5

CREATE TABLE permissions, 11.2.1.7

CREATE_INDEX_SCRIPT, 10.4

CREATE_POLICY_SCRIPT, 10.4, 10.4

CREATE_STOPLIST procedure, 3.3.4, 3.3.4.3

CTX_CLS.TRAIN procedure, 6.4

CTX_DDL.SYNC_INDEX procedure, 2.3, 3.5.2.1

CTX_DOC.POLICY_SNIPPET procedure, 5.1.3.3

CTX_DOC.SNIPPET procedure, 5.1.3.3

CTX_INDEX_ERRORS view, 3.4.1, 10.2

CTX_OUTPUT.END_QUERY_LOG, 4.1.19

CTX_OUTPUT.START_QUERY_LOG, 4.1.19

CTX_PENDING view, 10.2

CTX_REPORT, 3.5.3.5

CTX_REPORT package, 10.4

CTX_REPORT_QUERY_LOG_SUMMARY, 4.1.19

CTX_REPORT_TOKEN_TYPE, 10.4

CTX_REPORT.CREATE_INDEX_SCRIPT, 10.4

CTX_REPORT.CREATE_POLICY_SCRIPT, 10.4, 10.4

CTX_REPORT.DESCRIBE_INDEX, 10.4

CTX_REPORT.DESCRIBE_POLICY, 10.4

CTX_REPORT.INDEX_SIZE, 10.4

CTX_REPORT.INDEX_STATS, 10.4

CTX_REPORT.QUERY_LOG_SUMMARY, 10.4

CTX_REPORT.TOKEN_INFO, 10.4

CTX_THES package

about, 9.1.1.1

CTX_USER_INDEX_ERRORS view, 3.4.1, 10.2

CTX_USER_PENDING view, 10.2

CTXAPP role, 2.2, 10.1

CTXCAT grammar, 4.3

CTXCAT index

about, 3.1.1

about performance, 7.7.17

automatic synchronization, 2.4

creating, 2.4

example, 3.3.7

ctxkbtc

example, 9.3.2.5

ctxload

load thesaurus example, 9.1.1.3, 9.3.1, 9.3.2.4

CTXRULE index, 6.3.2

about, 3.1.1

allowable queries, 6.3.2

creating, 2.5.1, 3.3.8

lexer types, 6.3.2

limitations, 6.3.2

parameters, 6.3.2

CTXSYS user, 10.1

and DBA permissions, 11.2.1.1

and effective user, 11.2.1.3

and procedure ownership, 11.2.1.4

CREATE TABLE permissions, 11.2.1.7

migrating procedures owned by, 11.2.1.2, 11.2.2

preferences, 11.2.1.4

synching and optimizing other indexes, 11.2.1.5, 11.2.1.6

CTXXPATH index, 1.6.3.2

about, 3.1.1

D

data storage

index default, 3.3.6.2

preference example, 3.3.2.1.4

datastore

about, 3.1.3.1, 3.3.1

DATE column, 3.3.6.2

DBA permissions and CTXSYS, 11.2.1.1

DBMS_JOB.SUBMIT procedure, 3.5.2.1

Decision Tree supervised classification, 6.4.1

default thesaurus, 9.1.4

DEFAULT_INDEX_MEMORY, 7.8.2

defaults

index, 3.3.6.2

DESCRIBE_INDEX, 10.4

DETAIL_DATASTORE, 3.2.1.2.1

about, 3.2.1.8

diacritical marks

characters with, 3.2.8.2

DIRECT_DATASTORE, 3.2.1.2.1

about, 3.2.1.8

example, 3.3.2.1.1

DML

view pending, 3.5.1

DML processing

background, 10.5

DML queue, 10.2

document

classification, 3.3.8, 6

document format

affect on index performance, 7.8.4

affect on performance, 7.7.5

document formats

filtering, 3.2.2

supported, 3.2.1.7

document invalidation, 3.5.3.3

document presentation

about, 5.3

document sections, 3.3.3

document services

about, 5.3

DOMAIN_INDEX_NO_SORT hint

better throughput example, 7.3.2

drjobdml.sql script, 3.5.2.1

DROP INDEX command, 3.4.2

DROP_STOPLIST procedure, 3.3.4.3

dropping an index, 3.4.2

E

effective user, 11.2.1.3

EQUIV operator, 4.2.2

errors

DML, 10.2

viewing, 3.4.1

explain plan, 4.1.10

exporting statistics, 7.1

extensible query optimizer, 7.1

F

feedback

query, 4.1.9

field section

definition, 8.1.2.2

nested, 8.1.2.2.2

repeated, 8.1.2.2.3

visible and invisible, 8.1.2.2.1

file paths

storing, 3.2.1.3

FILE_DATASTORE, 3.1.3.1

about, 3.2.1.3, 3.2.1.8

example, 3.3.2.1.4

filter

about, 3.1.3.2, 3.3.1

filtering

custom, 3.2.2.3

index default, 3.3.6.2

to plain text and HTML, 5.3

filtering documents, 3.2.2

FIRST_ROWS hint, 4.2.9

better response time example, 7.2.2.1

better throughput example, 7.3.2

format column, 3.2.1.6, 3.2.2.2, 3.2.3

formats

filtering, 3.2.2

supported, 3.2.1.7

fragmentation of index, 3.5.3.2, 7.9.2

viewing, 3.5.3.5

full themes

obtaining, 5.2.1.2.2

functional lookup, 7.7.6

fuzzy matching, 3.2.9

default, 3.3.6.2

fuzzy operator, 4.2.5

G

garbage collection, 3.5.3.3

German

alternate spelling, 3.2.8.3

composite words, 3.2.8.4

gist

definition, 5.2

example, 5.2.2.1

GIST procedure, 5.2.2

grammar

alternative, 4.1.18

CTXCAT, 4.3

grammar CONTEXT, 4.2

granting roles, 2.2, 10.1.3

H

HASPATH operator, 8.3.4

examples, 8.3.4.8

HFEEDBACK procedure, 4.1.9

highlighting

about, 5.3

overview, 5.1

highlighting documents, 2.3

highlighting text, 5.1.1

highlighting themes, 5.1.2

hit count, 4.2.10

home air dirtier, A.1

HTML

filtering to, 5.3

indexing, 3.3.2.2, 8.1.1.1

indexing example, 2.3, A.2.2

searching META tags, 8.2.2

zone section example, 3.3.3.1, 8.2.1

HTML_SECTION_GROUP object, 3.3.3.1, 8.1.1.1, 8.2.1

with NULL_FILTER, 2.3, 3.3.2.2, A.2.2

I

IGNORE

format column value, 3.2.3

IGNORE format column value, 3.2.2.2

importing statistics, 7.1

index

about, 3.1

creating, 3.3, 3.3.5

dropping, 3.4.2

getting report on, 10.4

optimizing, 3.5.3, 3.5.3.6

rebuilding, 3.4.4

statistics on, 10.4

structure, 3.1.2, 3.5.3.1

synchronizing, 3.5.2, 10.5

viewing information on, 10.4

index defaults

general, 3.3.6.2

index engine

about, 3.1.3.5

index errors

viewing, 3.4.1

index fragmentation, 3.5.3.2, 7.9.2

index maintenance, 3.4

index memory, 7.8.2

index synchronization, 2.3

index types

choosing, 3.1.1

INDEX_SIZE, 10.4

INDEX_STATS, 10.4

INDEX_STATS procedure, 3.5.3.5

indexed lookup, 7.7.6

indexing

and views, 3.1.7

bypassing rows, 3.2.3

considerations, 3.2

overview of process, 3.1.3

parallel, 3.1.6, 7.8.5

resuming failed, 3.4.3

special characters, 3.2.6

indexing performance

FAQs, 7.8

parallel, 7.8.6

indexing time, 7.8.1

INPATH operator, 8.3.4

examples, 8.3.4.2

INSO_FILTER (deprecated), 11.1.1

INSO_OUTPUT_FORMATTING attribute (deprecated), 11.1.1

INSO_TIMEOUT attribute (deprecated), 11.1.1

INSOFILTER directive (deprecated), 11.1.1

J

Japanese indexing, 3.2.8.5

JAPANESE_LEXER, 3.2.8.5

Jdeveloper

Text wizard, 2.3.1, A, B

K

knowledge base

about, 9.4

augmenting, 9.3.2

linking new terms, 9.3.2.3

supported character set, 9.4

user-defined, 9.4.1

Korean indexing, 3.2.8.5

KOREAN_MORPH_LEXER, 3.2.8.5

L

language

default setting for indexing, 3.3.6.2

language specific features, 3.2.8

languages

indexing, 3.2.5

language-specific knowledge base, 9.4.1

lexer

about, 3.1.3.4, 3.3.1

and CTXRULE, 6.3.2

list of themes

definition, 5.2

obtaining, 5.2.1

loading text

about, 3.2.1

LOB columns

improving query performance, 7.7.11

indexing, 3.3.6.2

local partitioned index, 7.7.14

improved response time, 7.2.3

location of text, 3.2.1

logical operators, 4.2.2

M

magnet, pet see pet magnet

maintaining the index, 3.4

marked-up document

obtaining, 5.1.3.1

MARKUP procedure, 2.3, 5.1.3.1

MATCHES

about, 4.1.3

PL/SQL example, 3.3.8.3, 4.1.3.2

SQL example, 4.1.3.1

MATCHES operator, 2.5.1, 6.3.1

materialized views, indexes on

MAX_INDEX_MEMORY, 7.8.2

MDATA operator, 8.1.2.4

MDATA section, 8.1.2.4

memory allocation

index synchronization, 7.9.3

indexing, 7.8.2

querying, 7.7.10

META tag

creating zone section for, 8.2.2.1

metadata

adding, 8.1.2.4

removing, 8.1.2.4

section, 8.1.2.4

migrating from previous releases, 11

migrating procedures, 11.2.1.2

migrating to previous releases, 11.2.2

mixed formats

filtering, 3.2.2.2

mixed query, 8.1.2.4

MULTI_COLUMN_DATASTORE, 3.2.1.2.1

about, 3.2.1.8

example, 3.3.2.1.2

MULTI_LEXER, 3.2.5.2

example, 3.3.2.5

multi-language columns

indexing, 3.2.5.2

multi-language stoplist

about, 3.3.4.1

multiple CONTAINS

improving performance, 7.7.12

MVIEW see materialized views

N

NCLOB column, 3.3.6.2

NEAR operator, 4.2.4

NEAR_ACCUM operator, 4.2.4

nested zone sections, 8.1.2.1.3

NESTED_DATASTORE, 3.2.1.2.1

about, 3.2.1.8

NEWS_SECTION_GROUP object, 8.1.1.1

NOT operator, 4.2.2

NULL_FILTER, 3.1.3.2

example, 2.3, 3.3.2.2, A.2.2

NULL_SECTION_GROUP object, 8.1.1.1

NUMBER column, 3.3.6.2

O

offset information

highlight, 5.1.3.2

operator

MDATA, 8.1.2.4

operators

CATSEARCH, 4.3

CONTAINS, 4.2

logical, 4.2.2

thesaurus, 9.1.1.2

optimizing index, 3.5.3

example, 3.5.3.6

single token, 3.5.3.4

optimizing queries, 4.2.9, 7.1

FAQs, 7.7

response time, 7.2

statistics, 7.1

throughput, 7.3

with blocking operations, 7.6

OR operator, 4.2.2

ora

contains, 1.6.2

Oracle Enterprise Manager, 10.6

Oracle XML DB, 1.6

Oracle9i Text Manager, 10.6

out of line LOB storage

improving performance, 7.7.11

P

parallel indexing, 3.1.6, 7.8.5

partitioned table, 7.8.6

parallel queries, 7.5, 7.7.15

paramstring for CREATE INDEX, 3.3.5

partitioned index, 7.7.14

improved response time, 7.2.3

path section searching, 8.3.4

PATH_SECTION_GROUP

example, 8.3.4.1

pending DML

viewing, 3.5.1

pending updates, 10.2

performance tuning

indexing, 7.8

querying, 7.7

updating index, 7.9

pet magnet, A.1

gist, 5.3.3

illustration, 5.3

themes, 5.3.2

phrase query, 4.1.4

pizza shredder, A.1

plain text

indexing with NULL_FILTER, 3.3.2.2

plain text filtering, 5.3

PL/SQL functions

calling in contains, 4.2.8

preferences

and CTXSYS, 11.2.1.4

creating (examples), 3.3.2

creating with admin tool, 10.6

dropping, 3.4.5

previous releases, migrating from, 11

previous releases, migrating to, 11.2.2

printjoins character, 3.2.6.1

PROCEDURE_FILTER, 3.2.2.3

PSP application, A.2, B.2

Q

query

ABOUT, 4.2.1

analysis, 4.1.19

blocking operations, 7.6

case-sensitive, 4.1.8

CATSEARCH, 4.1.2, 4.1.2.1

CONTAINS, 4.1.1

counting hits, 4.2.10

CTXRULE, 6.3.2

getting report on, 10.4

log, 4.1.19

MATCHES, 4.1.3

mixed, 8.1.2.4

optimizing for throughput, 7.3

overview, 4.1

parallel, 7.5

speeding up with MDATA, 8.1.2.4

viewing information on, 10.4

viewing log of, 10.4

query analysis, 4.1.19

query application

example, 2.3

sample, 1.3.1

query explain plan, 4.1.10

query expressions, 4.1.7

query features, 4.1.20

query feedback, 4.1.9

query language, 4.1.16

query log, 4.1.19, 10.4

query optimization, 4.2.9

FAQs, 7.7

response time, 7.2

query performance

FAQs, 7.7

query relaxation, 4.1.15

query rewrite, 4.1.14

query template, 4.2.6, 4.3.1

QUERY_LOG_SUMMARY, 10.4

queue

DML, 10.2

R

rebuilding an index, 3.4.4

relaxing queries, 4.1.15

REMOVE_SQE procedure, 4.2.7.1

REMOVE_STOPCLASS procedure, 3.3.4.3

REMOVE_STOPTHEME procedure, 3.3.4.3

REMOVE_STOPWORD procedure, 3.3.4, 3.3.4.3

response time

improving, 7.2

optimizing for, 4.2.9

result buffer size

increasing, 7.6

resuming failed index, 3.4.3

rewriting queries, 4.1.14

roles

granting, 2.2, 10.1.3

system-defined, 10.1

rule-based classification, 6.3

S

sample application, A, B

scoring

alternative, 4.1.17

searching

XML, 1.6

section

attribute, 8.1.2.5

field, 8.1.2.2

groups and types, 8.1.2

HTML example, 3.3.3

MDATA, 8.1.2.4

nested, 8.1.2.1.3

overlapping, 8.1.2.1.2

repeated zone, 8.1.2.1.1

special, 8.1.2.6

stop section, 8.1.2.3

types and groups, 8.1.2

zone, 8.1.2.1

section group

about, 3.3.1

and section types, 8.1.2

creating with admin tool, 10.6

section searching

about, 4.1.12, 8.1

enabling, 8.1.1

HTML, 8.2.1

sectioner

about, 3.1.3.3

sectioning

automatic, 8.3.1

path, 8.3.4

security improvements in current release, 11.2.1

self-tipping couch, A.1

SGA memory allocation, 7.8.2

simple classification, see rule-based classification

single themes

obtaining, 5.2.1.2.1

size of index, viewing, 10.4

skipjoins character, 3.2.6.2

SORT_AREA_SIZE, 7.6, 7.7.10, 7.8.2

special characters

indexing, 3.2.6

special sections, 8.1.2.6

spelling

alternate, 3.2.8.3

SQE operator, 4.2.7

statistics

exporting and importing, 7.1

optimizing with, 7.1.1

stem operator, 3.2.9, 4.2.5

stemming

default, 3.3.6.2

improving performance, 7.7.13

stop section, 8.1.2.3

stopclass, 3.3.4.2, 3.3.4.2

stoplist, 3.3.4

about, 3.3.1

creating with admin tool, 10.6

default, 3.3.6.2

multi-language, 3.2.12.1, 3.3.4.1

PL/SQL procedures, 3.3.4.3

stoptheme, 3.3.4.2, 3.3.4.2

about, 3.2.12

definition, 4.1.6.1

stopword, 3.3.4, 3.3.4.2

about, 3.2.12, 4.1.5

case-sensitive, 4.1.8.1.1

storage

about, 3.3.1

STORE_SQE procedure, 4.2.7, 4.2.7.1

stored query expressions, 4.2.7

storing text, 3.2.1

about, 3.2.1.2

structure of index, 3.5.3.1

structured query

example, 3.3.7

supervised classification, 6.4

Decision Tree, 6.4.1

SVM supervised classification, 6.4.2

memory requirements, 6.4.2

SYN operator, 9.2.1

SYNC_INDEX procedure, 2.3, 3.5.2.1

synching and optimizing other indexes, 11.2.1.5, 11.2.1.6

synchronize index, 2.3

synchronizing index, 3.5.2, 10.5

improving performance, 7.9

synonyms

defining, 9.2.1

T

talking pillow, A.1

template queries, 4.2.6, 4.3.1

text column

supported types, 3.2.1.1

TEXT format column value, 3.2.2.2

text highlighting, 5.1.1

Text Manager tool, 10.6

text storage, 3.2.1

theme functionality

adding, 9.4.1

theme highlighting, 5.1.2

theme summary

definition, 5.2

themes

indexing, 3.2.8.1

THEMES procedure, 5.2.1

thesaural queries

about, 4.1.11

thesaurus

about, 9.1

adding to knowledge base, 9.3.2

case-sensitive, 9.1.2

DEFAULT, 9.1.4

default, 9.1.4

defining terms, 9.2

hierarchical relations, 9.2.2

loading custom, 9.3.1

operators, 9.1.1.2

supplied, 9.1.5

using in application, 9.3

thesaurus operator, 4.2.5

throughput

improving query, 7.3

tildes

indexing characters with, 3.2.8.2

TOKEN_INFO, 10.4

TOKEN_TYPE, 10.4

tracing, 7.4

TRAIN procedure, 6.4

tuning queries

for response time, 7.2

for throughput, 7.3

increasing result buffer size, 7.6

with statistics, 7.1

U

umlauts

indexing characters with, 3.2.8.2

unsupervised classification, 6.5

updating index performance

FAQs, 7.9

updating your applications, 11

URL_DATASTORE

about, 3.2.1.8

example, 3.3.2.1.3

URLs

storing, 3.2.1.4

user

creating Oracle Text, 2.2

system-defined, 10.1

USER_DATASTORE, 3.1.7

about, 3.2.1.8

USER_FILTER, 3.2.2.3

V

VARCHAR2 column, 3.2.1.1

viewing information on indexes and queries, 10.4

viewing size of index, 10.4

views

and indexing, 3.1.7

materialized

W

wildcard operator, 4.2.5

improving performance, 7.7.13

WITHIN operator, 3.3.3

wizard

Oracle Text addin, 2.3.1, A, B

word query, 4.1.4

case-sensitivity, 4.1.8.1

wordlist

about, 3.3.1

X

XML DB, 1.6

XML documents

attribute searching, 8.3.2

doctype sensitive sections, 8.3.3

indexing, 8.1.1.1

section searching, 8.3

XML searching, 1.6

XML_SECTION_GROUP object, 8.1.1.1

Z

zone section

definition, 8.1.2.1

nested, 8.1.2.1.3

overlapping, 8.1.2.1.2

repeating, 8.1.2.1.1