Index

creating, 1

D

Danish

alternate spelling, 15.3.2

index defaults, 2.11.3.1.2

supplied stoplist, E.4

data storage

defined procedurally, 2.2.6

direct, 2.2.1

example, 7

external, 2.2.4

master/detail, 2.2.3

URL, 2.2.5

datastore types, 2.2

DATE column, 1

DBMS_PCLUTIL

BUILD_PART_INDEX, 1

default index

example, 1

default parameters

changing, 2.12.2.5

CONTEXT index, 2.12.2.1

CTXCAT index, 2.12.2.2

CTXRULE index, 2.12.2.3< /a>

viewing, 2.12.2.4

DEFAULT thesaurus, < a href="cqoper.htm#sthref971">3.1.5, 3.1.5

DEFAULT_CTXCAT_INDEX_SET sys tem parameter, 2.12.2.2

DEFAULT_CTXCAT_LEXER system parameter, 2.12.2.2

DEFAULT_CTXCAT_STOPLIST system parameter, 2 .12.2.2

DEFAULT_CTXCAT_STORAGE system parameter, 2.12.2.2

DEFAULT_CTXCAT_WORDLIST system parameter, 2.12.2.2

DEFAULT_CTXRU LE_LEXER system parameter, 2.12.2.3

DEFAULT_CTXRULE_STOPLIST system parame ter, 2.12.2.3

DEFAULT_CTXRULE_WORDLIST system parameter, 2.12.2.3, 2.12.2.3

DEFAULT_DATASTORE system parameter, 2.12.2.1

DEFAULT_DATASTORE system-defined indexing preference, 2.11.1.1

DEFAULT_FILTER_BINARY system parameter, 2. 12.2.1

DEFAULT_FILTER_FILE system parameter, 2.12.2.1

DEFAULT_FILTER_TEXT system parameter, 2.12.2.1

DEFAULT_INDEX_MEMORY system parameter, 2.12.1

DEFAULT_LEXER system parameter, 2.12.2.1

DEFAULT_LEXER system-defined indexing preference, 2.11.3.1

DEFAULT_RULE_STORAGE system parameter, 2.12.2.3

DEFAULT_SECTION_HTML system parameter, 2.12.2.1

DEFAULT_SECTION_ TEXT system parameter, 2.12.2.1

DEFAULT_STOPLIST system parameter, 2.12.2.1

DEFAULT_STOPLIST system-defined preference, 2.11.5.1

DEFAULT_STORAGE system parameter, 2.12.2.1

DEFAULT_STORAGE system-defined preference, 2.11.6.1

DEFAULT_WORDL IST system parameter, 2.12.2.1

DEFAULT_WORDLIST system-defined preference, 2.11.7.1

defaults for indexing

viewing, G.14

derivational stemming

enabling for English, 2.5.1

DESCRIBE_INDEX pr ocedure, 11.2

DESCRIBE_POLICY procedure, 11.2

describing an index, 11.2

DETAIL_DATASTORE object, 2.2.3

example, 2.2.3.2

detail_key attribute, 2.2.3

detail_lineno attribute, 2.2.3

detail_table attribute, 2.2.3

detail_text attribute, 2.2.3

dictionary

Chinese, 14.3

Ja panese, 14.3

Korean, 2.4.8.1

modifying, 14.3

user, 2.4.1.1

DIRECT_DATASTORE object, 2.2.1

example, 2.2.1.1

E

email

filtering and indexing, 2.3.4

empty indexes

creating, 1

EMPTY_STOPLIST system-defined preference, 2.11.5.2

enabling tracing, 9

END_LOG procedure, 9

END_QUERY_LOG procedure, 9

ending a log, 9

ending a query log, 9

< dd class="l1ix">endjoins attribute, 2.4.1

English

fuzzy matching, 2.5.1

index defaults, 2.11.3.1.1

supplied stoplist, E.1

english attribute (Korean lexer), 2.4.8.4

environment varia bles

setting for Inso filter, B.1.3

equivalence operator, 3.1.5

stopwor d transformations, H.1.7

with NEAR, 3.1.5

errors

indexing, 1

escape character, 4.2

escaping special cha racters, 4.2

event

adding, 9

removing, 9

EVERY parameter, 1, 1

example, 1

EXP_TAB table type, A.3.1

expansion operator

soundex, 3.1.5

stem, 3.1.5

viewing, 10

< /dd>

EXPLAIN procedure, 10

example , 10

result table, A.1.1

explain table

creating, 10

retrieving data example, 10

structure, A.1.1

extending knowledge base, 14.2

external filters

specifying, 2.3.5

F

failed index operation

resuming, 1

< /dd>

fast filtering, 2.3.2, 2.3.4

features

new, Preface

< dd class="l1ix">field section

defining, 7

limitations, 7

querying, 3.1. 5

field sections

adding dynamically, 1

repeated, 3.1.5

WITHIN example, 3.1.5

file data storage

example, 7

FILE_DATASTORE object, 2.2.4

example, 2.2.4.2

FILE_DATASTORE system-defined preference, 2.11.1.2

filter att ribute

MULTI_COLUMN_DATASTORE, 2.2.2

filter formats

supported, B.2

FILTER procedure, 8

e xample, 8

in-memory example, 8

< dd class="l2ix">result table, A.2.1

G

German

alte rnate spelling attribute, 2.4.1.1

alternate spelling conventions, 15.3.1

composite word indexing, 2.4.1

fuzzy matching, 2.5.1

index defaults, 2.11.3.1.4

new spelling, querying with, 2.4.1.1, 15.1.3

stemming, 2.5.1

sup plied stoplist, E.8

GET_TRACE_VALUE procedure, 9

Gist

generating, 8

gist

generating, 8

GIST procedure

example, 8

result table, A.2.2

updated synt ax, 8

Gist table

st ructure, A.2.2

H

hanja attribute, 2.4.8.4

HASPATH operator, 3.1.5

HFEEDBACK procedure, 10

example, 10

result table, A.1.2

hierarchical clustering, 2.9.2

hierarchical query feedback information

generating, 10

hierarchical relationships

in thesaurus import file, C.3.1

HIER ARCHY_DEPTH attribute, 2.9.2

HIGHLIGHT procedure, 8

example, 8

res ult table, A.2.3

highlight table

example, 8

structure, A.2.3

highlighting

generating markup, 8, 8

generating offsets, 8, 8

with NEAR operator, 3.1.5

hit counting, 10

HOME environment variable< /dd>

setting for INSO, B.1.4

homographs

in broader term queries, 3.1.5

in queries, 3.1.5

in thesaurus import file, C.3.2

HTML

bypassing filtering, 2.3.2.2

filtering to, 8

generating, 8

generating highlight offsets for, 8, 8

highlight markup, 8< /a>, 8

highlighting example, 8

< dd class="l2ix">indexing, 1, 2.3.3.1, 2.7, 7

zone section example, 7

I

i_index_clause attribute, 2.6.1

i_table_cl ause attribute, 2.6.1

IFILTER procedure, 8

IGNORE

format column value, 1

import file

examples of, C.3.4

structure, C.3

index

creating, 1

creating a report on, 11.2

creating index script, 11.2

describing, 11.2

duplicating with script, 11.2

renaming, 1

script, 11.2

show size of objects, 11.2

s how statistics, 11.2

synchronizing, 1, 1

transactional, 10

tr ansactional CONTEXT, 1, 1

viewing registered, G.2

index creation

c ustom preference example, 1

default example, 1

index creation parameters

example, 2.6.1.2

index errors

deleting, 1

viewing, 1

index f ragmentation, 1

index maintenance, 1

index objects, 2

viewing, G.4, G.11

index optimization, 1

index preference

about, 2.1

creating, 2.1.1, 7< /a>

index reports, 11

index requests

logging, 9

index tablesp ace parameters

specifying, 2.6

index tokens

generating for a document, 8, 8

INDEX_PROCEDURE user_lexer attribute, 2.4.9.3

INDEX_SIZE procedure, 11.2

INDEX_STATS procedure, 11.2

index_stems attribute, 2.4.1.1

index_text attribute, 2.4.1.1

index_themes attribute, 2.4.1.1

indexing

master/detail example, 2.2.3.2.4

multilingual documents, 2.4.2, 2.4.10, D.2.5

parallel, 1, 1

themes, 2.4.1.1

indexing types

cl assifier, 2.8.1

clustering, 2.9

datastore, 2.2

filter, 2 .3

lexer, 2.4

section group, 2.7

storage, 2.6

vs. preferences, 2.1.1

wordlist, 2.5

indexless document services, see policy-based document services

indextype context, 1

inflectional stemming

enabling, 2.5.1

INPATH operator, 3.1.5

INPUT_TYPE user_lexer attribute, 2.4.9.4

INSERT statement

loading example, C.1

Inso filter

index preference object, 2.3.2

setting up, B.1

supported formats, B.2

supported platforms, B.1.2, B.1.2.1

unsupported formats, B.3

IN SO_FILTER object, 2.3.2

and transactional CONTEXT i ndexes, 1

character-set conversion, 2.3.2.3

INSO_FILTER system-defined preference, 2.11.2.2

INSO_OUTPUT_FORMATTING attribute, 2.3.4

inverse frequency scoring , F.1

Italian

fuzzy matching, 2.5.1

stemming, 2.5.1

supplied stoplist, E.9

J

JA16EUC character set, 2.4.5.2, 2.4.6.3

JA16EUCTILDE character set, 2.4.5.2, 2.4.6.3

JA16EUCYEN character set, 2.4.5.2, 2.4.6.3

JA16SJIS character set, 2.4.5.2, 2.4.6.3

JA16SJISTILDE character set, < a href="cdatadic.htm#sthref569">2.4.5.2, 2.4.6.3

JA16SJISYEN character set, 2.4.5.2, 2.4.6.3

Japanese

fuzzy matching, 2.5.1

index defaul ts, 2.11.3.1.6

indexing, 2.4.5

< dd class="l2ix">stemming, 2.5.1

K

k_table_clause attribute, 2.6.1

KMEAN_CLUSTER object, 2.9.1

knowledge b ase

supported character set, 14.2.1

user-defined, 14.2.8

knowledge base extension compiler, 14.2

KO16KSC5601 character set, 2.4.7.1, 2.4.8.2

KO16MSWIN949 character set, 2.4.8.2< /a>

Korean

fuzzy matching, 2.5.1< /a>

index defaults, 2.11.3.1.7

unicode character sup port, 2.4.8.3

korean character sets supported, 2.4.7.1, 2.4.8.2

Korean text

indexing, 2.4.8

KOREAN_LEXER object, 2.4.7

KOREAN_MORP_LEXER, 2.4.8

composite example, 2.4.8.6

supplied dictio naries, 2.4.8.1

KOREAN_MORPH_LEXER

< dd class="l2ix">Unicode support, 2.4.8.3

L

language

setting, 2.4

language column, 1

left-truncated searching

improving performance, 2.5.1

lexer types, 2.4

lexical compiler, 14.3

lexicon. See entries under dictiona ry

loading text

SQL INSERT example, C.1

SQL*Loader example, C.2

loadin g thesaurus, 14.1

LOB columns

l oading, C.2

local partition index

parallelism, 1

local partitioned index, 1

LOG_DIRECTORY system parameter, 2.12.1, 9

LOG_TRACES procedure, 9

LOG FILENAME procedure, 9

logging

ending, 9

ending a log, 9

getting log file name, 9

index requests, 9

logging queries, 11.2

lo gging traces, 9

logical operators

with NEAR, 3.1.5

LONG columns

indexing, 1

M

mail filter configuration file, 2.3.4.2

mail filtering, see email, 2.3.4

MAIL_FILTER object, 2.3.4

MAIL_FILTER_CONFIG_FILE system parameter, 2.3.4.2

maintaining index, 1

MARKUP procedure, 8

example, 8

HTML highlight example, 8

result table, A.2.4

markup table

example, 8

structure, A.2.4

master/detail d ata storage, 2.2.3

example, 2.2.3.2, 7

master/detail tables

indexing example, 2.2.3.2.4

MATCHES o perator, 1

MAX_INDEX_MEMORY system parameter, 2.12.1

max_span parameter in near operator, 3.1.5

maxthreads attribute, 2.2.5.2

maxurls attribute, 2.2.5.2

MDATA operator, 3.1.5

MDATA sec tion, 7, 7, 7

memory

for index synchronize, 1

for indexing, 1, 1, 1, 7

META tag

creating field sections for, 7

creating zone section for, 7

metadata, 1, 3.1.5

replacing, 7

METAD ATA keyword, 1

ALTER INDEX example, 1

metadata section, 7, 7, 7

MINUS operator, 3.1.5

stopword transformations, H.1.5

mixed character-set columns

indexing, 2.3.1. 2

mixed_case attribute, 2.4.1

mixed-fo rmat columns

filtering, 2.3.2

indexing, 2.3.2.2

supported formats for, B.2

modifying user dictionary, 14.3

mo rpheme attribute, 2.4.8.4

MULTI_LEXER object

< dd class="l2ix">CREATE INDEX example, 1

example, 2.4.2.2

n_table_clause attribute, 2.6.1

narrower term operators

example, 3.1.5

narrower term query feedback, 10

NEAR operator

backward compatibility, 3.1.5

highlighting, 3.1.5

scoring, 3.1.5

stopword transformations, H.1.8

with other operators, 3.1.5

with within, 3.1.5

nested section searching, 3 .1.5

nested zone sections, 7

nested_column attri bute, 2.2.7

NESTED_DATASTORE attribute, 2 .2.7.1

NESTED_DATASTORE object, 2.2.7

nested_lin eno attribute, 2.2.7

nested_text attribute, 2.2.7

nested_type attribute, 2.2.7

new featur es, Preface

new_german_spelling attribute, 2.4.1.1, 15.1.3

newline attribute, 2. 4.1

NEWS_SECTION_GROUP object, 2.7, 7

no_proxy attribute, 2.2.5.2

nopopulate index pa rameter, 1

nopopulate parameter, 1

normalized word forms, 15.1

Norwegian

index defaults, 2.11.3.1.5

NOT operator, 3.1.5

stopword transformations, H.1.6

NT function, 12

NT oper ator, 3.1.5

NTG function, 12

NTG operator, 3.1.5

NTI function, 12

NTI operator, 3.1.5

NTP function, 12

NTP operator, 3.1.5

NULL_F ILTER object, 2.3.3

NULL_FILTER system-defined preference, 2.11.2.1

NULL_SECTION_GROUP object, 2.7, 7

NULL_SECTION_GROUP system-defined preference, 2.11 .4.1

number attribute, 2.4.8.4

NUMBER column, 1

numgroup attribute, 2.4.1

numjoin attribute, 2.4.1

O

object values

v iewing, G.10

objects

viewing index, G.11

offsets for highlighting, 8, 8

on commit, 1, 1

one_char_word attribute, 2.4.8.4

OPERATION column of explain table

values, A .1.1.1

OPERATION column of hfeedback table

values, < a href="arestab.htm#sthref2228">A.1.2.1

operator

ABO UT, 3.1.5

accumulate, 3.1.5

broader term, 3.1.5

equivalence, 3.1 .5

fuzzy, 3.1.5

HASPATH, 3.1.5

INPATH, 3.1.5

MDATA, 3.1.5

MINUS, 3.1.5

narrower term, 3.1.5

NEAR

NOT, 3.1. 5

OR, 3.1.5

preferred term, 3.1.5

related term, 3.1.5

soundex, 3.1.5

SQE, 3.1.5

ste m, 3.1.5

synonym, 3.1.5

threshold, 3.1.5

top term, 3.1.5

translation term, 3.1.5

translation term synonym, 3.1.5

weight, 3.1.5

WITHIN, 3.1.5

operator expansion

viewing, 10

operator precedence, 3.1

examples, 3.1.4

viewing, 10

operators, 3

optimization, 7

strategies , 7

OPTIMIZE_INDEX procedure, 7

optimizing index, 1

OPTIONS column

explain table, A.1.1.2

hfeedback table, A.1.2.2

OR operator, 3.1.5

stopword transformations, H.1.3

original word forms, 15.1

OUTPUT_FORMATTING attribute, 2.3.2

OUTPUT_STYLE procedure, 12

output_type attribute, 2.2.6.2

overlapping zone sections, 7

override_base_letter attribute, 15.2.1

overriding alternate spelling, 15.2

overriding base-letter conv ersions, 15.2.1

P

p_table_clause, 2.6.1

PARAGRAPH keyword, 3.1.5

paragraph section

defining, 7

querying, 3.1 .5

parallel index creation, 1

parallel ind exing, 1, 1, 1

DBMS_PCLUTIL.BUILD_PART_INDEX, 1

example, 1

local partitioned index, 1

parameter

transactional, 1, 1

parameters

setting, 5

viewing system-defined, G.14

parentheses

altering precedence, 3.1.5, 4.1

grouping character, 4.1

partitioned index

creating local in parallel, 1

example, 1

local, 1

parallel creation, 1

rebuild example, 1

partitioned index creation

example, 1

partitioned tables

modifyi ng, 1

path attribute, 2.2.4

PATH environment variable

setting for Inso, B.1.4

PATH_SECTION_GROUP

querying with, 3.1.5

PATH_SECTION_GROUP object, 2.7 , 7

PATH_SECTION_GROUP system-defined preference, 2.11.4.4

pending DML

viewing, G.15

performance

wildcard searches, 3.1.5

PKENCODE function, 8

plain text

bypassing filtering, 2.3.2 .2

filtering to, 8, 8

highlight markup, 8, 8

ind exing with NULL_FILTER, 2.3.3.1

offsets for highlighting, 8

policy, 8

create script, 11.2

duplicate with script, 11.2

report describing, 11.2

POLICY_FILTER procedure, 8

POLICY_GIST procedure, 8

POLICY_HIGHLIGHT procedure, 8

POLICY_MARKUP procedure, 8

POLICY_THEMES procedure

syntax, 8

POLICY_TOKENS procedure

syntax, 8

policy-based docu ment services, 8

populate index parameter, 1< /a>

populate parameter, 1

Portuguese

supplied stoplist, E.10

precedence of operators, 3.1

altering, 3.1.5, 4.1

equivalence operator, 3.1 .5

example, 3.1.4

viewing, 10

preference classes

viewing, G.1

preference values

viewing, G.17

preferences

abo ut, 2.1

changing, 1

creating, 7

dropping, 7

replacing, 1

specifying for indexing, 1

system-defined, 2.11

viewing, G.16

vs. types, 2.1.1

pre ferred term operator

example, 3.1.5

< dd class="l1ix">prefix_index attribute, 2.5.1

prefix_length_max attribute, 2.5.1

prefix_length_min attribute, 2.5.1

printjoins attribute, 2.4.1

privileges

required for indexing, 1

proced ure

CTX_DDL.REPLACE_INDEX_METADATA, 7

CTX_OUTPUT_LOG_TRACES, 9

CTX_OUTPUT.ADD_TRACE, 9

CTX_OUTPUT.END_QUERY_LOG, 9

CTX _OUTPUT.GET_TRACE_VALUE, 9

CTX_OUTPUT.REMOVE_TRACE, 9

CTX_OUTPUT.RESET_TRACE, 9

procedure attribute, 2.2.6

PROCEDURE_FILTER object, 2.3.6

progressive relaxation template, 1

prove_themes attribute, 2.4.1.1

proximity operator, see NEAR operator

PT function, 12

PT operator, 3.1.5

punctuations attribute, 2.4.1

query

accumulate, 3.1.5

analysis, 11.2

AND, 3.1.5

broader term, 3.1.5

equivalence, 3.1.5

exam ple, 1

hierarchical feedback, 10

MINUS, 3.1.5

narrower term, 3 .1.5

NOT, 3.1.5

on unsynched index, 1

OR, 3.1.5

preferred term, 3.1.5

related term, 3.1.5

report of logged, 11.2

stored, 3.1.5

synonym, 3.1.5

threshold, 3.1.5

top term, 3.1.5

transactional, 1, 10

translation term, 3.1.5

translation term synonym, 3.1.5

weighted, 3.1.5

query relaxation template, 1

query rewrite template, 1

query template, < a href="csql.htm#sthref107">1, 1

QUERY_LOG_SUMMARY procedure, 11.2

QUERY_PROCEDURE user_lexer attribute, 2.4.9.5

R

r_table_clause attribute, 2.6.1

rebuilding index

example, 1

syntax, 1< /dd>

RECOVER procedure, 5

related term operator , 3.1.5

related term query feedback, 10

relaxing queries, 1

relevance ranking

word queries, F.1

REMOVE_EVENT proce dure, 9

REMOVE_MDATA procedure, 7

REMOVE_SECTION procedure, 7

REMOVE_SQE procedure, 10

REMOVE_STOPCLASS procedure, 7

REMOVE_STOPTHEME procedure, 7

REMOVE_STOPWORD procedure, 7

REMOVE_TRACE procedure, 9

removing a trace, 9

removing metadata, 7

renaming index, 1

repeated field sections

querying, 3.1.5

REPLAC E_INDEX_METADATA procedure, 7

replacing, 1

replacing metadata, 1

replacing preferences, 1

report

describing index, 11.2

describing policy, 11.2

inde x objects, 11.2

index size, 11.2

index statistics, 11.2

of logged queries, 11.2

token information, 11.2

reserved words and characters, 4.3

escapin g, 4.2

RESET_TRACE procedure, 9< /a>

resetting a trace, 9

result table

TOKENS, A.2.6

result tables, A

CTX_DOC, A.2

CTX_QUERY, A.1

CTX_THES, A.3

resuming failed index, 1

example, 1

rewriting queries, 1

RFC 1738 URL specification, 2.2.5.1

RFC-2045 messages

filtering, 2.3.4

RFC-822 messages

filtering, 2.3.4

RT function, 12

RT operator, 3.1.5

RULE_CLASSIFIER type, 2.8.1

rules< /dd>

generating, 6

S

Salton's formula for sc oring, F.1

scope notes

finding , 12

SCORE operator, 1

scoring

accumulate, 3.1.5

effect of DML, F.1.2

for NEAR operator, 3.1.5

scoring algorithm

word queries, F.1

script

create index, 11.2

create policy, 11.2

section group

creating, 7

viewing information about, G.19

section group example , 2.7.1

section group types, 2.7, 7

section searching, 3.1.5

nested, 3.1.5

sections

< dl class="l2ix">

adding dynamically, 1

constraints for dynamic addition, 1

creating attribute, 7

creating field, 7

creating zone, 7

nested, 7

overlapping, 7

removing, 7

repeated field, < a href="cddlpkg.htm#sthref1266">7

repeated zone, 7

viewing information on, G.18