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.3

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.5

ALTER INDEX statement

rebuilding index, 3.4.5

resuming failed index, 3.4.3

alternate spelling, 3.2.8.4

alternative grammar, 4.1.18

alternative grammar template, 4.1.18

alternative scoring, 4.1.17

alternative scoring template, 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.6

AUTO_FILTER filter, 3.1.3.2, 3.2.2, 3.2.4, 7.9.4

AUTO_LEXER

indexing columns and, 3.2.5

language detection and, 3.2.4.2

AUTO_LEXER lexer type, 3.2.8.1

AUTO_LEXER with fuzzy matching and stemming, 3.2.9

AUTO_SECTION_GROUP object, 8.1.1.1

automatic sections, 8.3.1

B

background DML, 10.6

base-letter conversion, 3.2.8.3

BASIC_LEXER, 3.2.5

BASIC_SECTION_GROUP object, 8.1.1.1

BFILE column, 3.2.1.1

indexing, 3.3.5.2

BINARY format column value, 3.2.2.2

BLOB column, 3.2.1.1

indexing, 3.3.5.2

blocking operations

tuning queries with, 7.7

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.6.3

operators, 4.3

SQL example, 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.3

character set column, 3.2.1.6

charset column, 3.2.4.3

CHARSET_FILTER, 3.1.3.2, 3.2.4

Chinese indexing, 3.2.8.6

CHINESE_VGRAM_LEXER, 3.2.8.6

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.5.2

clustering, see unsupervised classification

column types

supported for indexing, 3.2.1.1

composite words

indexing, 3.2.8.5

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.5

HTML example, 2.3, 3.3.5.5, A.2.2

couch, self-tipping, A.1

counting hits, 4.2.10

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

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.8.17

automatic synchronization, 2.4

creating, 2.4

example, 3.3.6

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

lexer types, 6.3.2

limitations, 6.3.2

parameters, 6.3.2

CTXSYS user, 10.1

CTXXPATH index, 1.5.3.2

about, 3.1.1

D

data storage

index default, 3.3.5.2

preference example, 3.3.2.1.4

datastore

about, 3.1.3.1, 3.3.1

DATE column, 3.3.5.2

Decision Tree supervised classification, 6.4.1

default thesaurus, 9.1.4

DEFAULT_INDEX_MEMORY, 7.9.2

defaults

index, 3.3.5.2

DEFINEMERGE operator, 4.2.11

DEFINESCORE operator, 4.2.11

DESCRIBE_INDEX, 10.4

DETAIL_DATASTORE, 3.2.1.2.1

about, 3.2.1.8

diacritical marks

characters with, 3.2.8.3

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.6

DML queue, 10.2

document

classification, 3.3.7, 6

document format

affect on index performance, 7.9.4

affect on performance, 7.8.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

DROP INDEX statement, 3.4.2

DROP_STOPLIST procedure, 3.3.4.3

dropping an index, 3.4.2

E

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.5.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

FIRST_ROWS(n) hint, 7.2.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.10.2

viewing, 3.5.3.5

full themes

obtaining, 5.2.1.2.2

functional lookup, 7.8.6

fuzzy matching, 3.2.9

default, 3.3.5.2

fuzzy operator, 4.2.5

G

garbage collection, 3.5.3.3

German

alternate spelling, 3.2.8.4

composite words, 3.2.8.5

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

dropping, 3.4.2

fragmentation, 3.5.3.2

getting report on, 10.4

incrementally creating, 3.3.5.3

maintenance, 3.4

online recreation, 3.4.4.1

optimizing, 3.5.3, 3.5.3.6

rebuilding, 3.4.5

statistics on, 10.4

structure, 3.1.2, 3.5.3.1

synchronizing, 3.5.2, 10.6

viewing information on, 10.4

index defaults

general, 3.3.5.2

index engine

about, 3.1.3.5

index errors

viewing, 3.4.1

index fragmentation, 7.10.2

index memory, 7.9.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.8.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.9.5

resuming failed, 3.4.3

special characters, 3.2.6

indexing performance

FAQs, 7.9

parallel, 7.9.6

indexing time, 7.9.1

INPATH operator, 8.3.4

examples, 8.3.4.2

INSO_FILTER (deprecated), 11.2.1

INSO_OUTPUT_FORMATTING attribute (deprecated), 11.2.1

INSO_TIMEOUT attribute (deprecated), 11.2.1

INSOFILTER directive (deprecated), 11.2.1

J

Japanese indexing, 3.2.8.6

JAPANESE_LEXER, 3.2.8.6

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.6

KOREAN_MORPH_LEXER, 3.2.8.6

L

language

default setting for indexing, 3.3.5.2

language detection

AUTO_LEXER, 3.2.8.1

language specific features, 3.2.8

languages

indexing, 3.2.5

language-specific feature

AUTO_LEXER, 3.2.8.1

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.8.11

indexing, 3.3.5.2

local partitioned index, 7.8.14

improved response time, 7.2.3

location of text, 3.2.1

locking parameter for sync_index, 3.5.2.3

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.7.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.9.2

maxtime parameter for sync_index, 3.5.2.2

MDATA operator, 8.1.2.4

MDATA section, 8.1.2.4

memory allocation

index synchronization, 7.10.3

indexing, 7.9.2

querying, 7.8.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

mixed formats

filtering, 3.2.2.2

mixed query, 8.1.2.4, 8.1.2.5

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.8.12

MVIEW see materialized views

N

NCLOB column, 3.3.5.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

NOPOPULATE keyword

and incremental rebuild,and replace parameter, 3.3.5.3

nopopulate with RECREATE_INDEX_ONLINE, 3.4.4.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.5.2

O

offset information

highlight, 5.1.3.2

online

recreating a CONTEXT indextype, 3.4.4.1

operator

MDATA, 8.1.2.4

SDATA, 8.1.2.5

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.8

response time, 7.2

statistics, 7.1

throughput, 7.3

with blocking operations, 7.7

OR operator, 4.2.2

ora

contains, 1.5.2

Oracle Enterprise Manager, 10.5

Oracle Enterprise Manager and Oracle Text, 10.5

Oracle Text pages in OEM, 10.5

Oracle XML DB, 1.5

out of line LOB storage

improving performance, 7.8.11

P

parallel indexing, 3.1.6, 7.9.5

partitioned table, 7.9.6

parallel queries, 7.6, 7.8.15

across Real Application Clusters (RAC) nodes, 7.6

partitioned index, 7.8.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.9

querying, 7.8

updating index, 7.10

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

POPULATE_PENDING, 3.3.5.4

preferences

creating (examples), 3.3.2

creating with admin tool, 10.5

dropping, 3.4.6

previous releases, migrating from, 11

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

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, 8.1.2.5

optimizing for throughput, 7.3

overview, 4.1

parallel, 7.6

speeding up with MDATA, 8.1.2.4

speeding up with SDATA, 8.1.2.5

viewing information on, 10.4

viewing log of, 10.4

query analysis, 4.1.19

query application

example, 2.3

sample, 1.2.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.8

response time, 7.2

Query Parallelized Across Oracle RAC Nodes, 7.6.2

query performance

FAQs, 7.8

query relaxation, 4.1.15

query relaxation template, 4.1.15

query rewrite, 4.1.14

query rewrite template, 4.1.14

query template, 4.2.6, 4.3.1

lang parameter and, 4.1.16

Query Templates, 4.1.13

QUERY_LOG_SUMMARY, 10.4

queue

DML, 10.2

R

Real Application Clusters (RAC) and parallel queries, 7.6

rebuilding an index, 3.4.5, 3.4.5

RECREATE_INDEX_ONLINE, 3.4.4.1

and DML, 3.4.4.1

recreating a local partitioned index online, 3.4.4.1

recreating an index, 3.4.4

recreating an index online, 3.4.4.1

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

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

SDATA operator, 8.1.2.5

SDATA section, 8.1.2.5

searching

XML, 1.5

section

attribute, 8.1.2.6

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

SDATA, 8.1.2.5

special, 8.1.2.7

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.5

section searching, 4.2.3

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

self-tipping couch, A.1

SGA memory allocation, 7.9.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.7, 7.8.10, 7.9.2

special characters

indexing, 3.2.6

special sections, 8.1.2.7

spelling

alternate, 3.2.8.4

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.5.2

improving performance, 7.8.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.5

default, 3.3.5.2

multi-language, 3.2.12.2, 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 expression, defining, 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 data

adding, 8.1.2.5

removing, 8.1.2.5

section, 8.1.2.5

structured query

example, 3.3.6

supervised classification, 6.4

Decision Tree, 6.4.1

SVM supervised classification, 6.4.2

memory requirements, 6.4.2

swap and noswap with RECREATE_INDEX_ONLINE, 3.4.4.1

SYN operator, 9.2.1

sync_index locking parameter, 3.5.2.3

sync_index maxtime parameter, 3.5.2.2

SYNC_INDEX procedure, 2.3

synchronize index, 2.3

synchronizing index, 3.5.2, 10.6

improving performance, 7.10

synonyms

defining, 9.2.1

T

talking pillow, A.1

template queries, 4.2.6, 4.3.1

templates, 4.1.13

query rewrite, 4.1.14

text column

supported types, 3.2.1.1

TEXT format column value, 3.2.2.2

text highlighting, 5.1.1

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.2

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.3

TOKEN_INFO, 10.4

TOKEN_TYPE, 10.4

tracing, 7.5

TRAIN procedure, 6.4

tuning queries

for response time, 7.2

for throughput, 7.3

increasing result buffer size, 7.7

with statistics, 7.1

U

umlauts

indexing characters with, 3.2.8.3

unsupervised classification, 6.5

updating index performance

FAQs, 7.10

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.8.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.5

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.5

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