Oracle Application Developer's Guide -- Index

ABOUT query, 3-13

adding for your language, 7-13

case-sensitivity, 3-11

definition, 3-8

example, 1-19

accents

indexing characters with, 2-17

ACCUM operator, 3-14

ADD_STOPCLASS procedure, 2-27

ADD_STOPTHEME procedure, 2-27

ADD_STOPWORD procedure, 2-26, 2-27

ADD_SUB_LEXER procedure

example, 2-24

administration tool, 8-6

ALTER INDEX command

rebuilding index, 2-37

resuming failed index, 2-37

alternate spelling, 2-17

AND operator, 3-14

application

sample, A-1, B-1

attribute

searching XML, 6-12

attribute sections, 6-8

AUTO_SECTION_GROUP object, 6-3

automatic sections, 6-12

background DML, 8-5

base-letter conversion, 2-17

BASIC_LEXER, 2-14

BASIC_SECTION_GROUP object, 6-2

BFILE column, 1-9

indexing, 1-12, 2-28

BINARY

format column value, 2-13

BLOB column, 1-9

indexing, 1-12, 2-28

blocking operations

tuning queries with, 5-12

bypassing rows, 2-13

case-sensitive

ABOUT query, 3-11

indexing, 2-16

queries, 3-10

thesaurus, 7-3

CATSEARCH, 3-4

creating index for, 2-31

operators, 3-18

SQL example, 3-4

structured query, 3-5

CHAR column, 1-9

character set

indexing, 2-14

indexing mixed, 2-14

character set column, 1-8

charset column, 2-14

CHARSET_FILTER, 2-5, 2-14

Chinese indexing, 2-18

CHINESE_VGRAM_LEXER, 2-18

classification

about, 1-2

CLOB column, 1-9

indexing, 1-12, 2-28

column types

supported for indexing, 1-9

composite words

indexing, 2-18

concept query, See ABOUT

CONTAINS

operators, 3-13

PL/SQL example, 3-3

query, 3-2

SQL example, 3-2

structured query, 3-3

CONTEXT grammar, 3-13

CONTEXT index, 1-2

about, 1-12, 2-9

creating, 1-12, 2-21, 2-28

customizing, 1-13

HTML example, 2-29, A-3

counting hits, 3-20

CREATE INDEX command, 2-28

CREATE_STOPLIST procedure, 2-26, 2-27

CTX_CLS.TRAIN procedure, 1-2

CTX_DDL.SYNC_INDEX procedure, 2-40

CTX_DOC package, 4-2

CTX_INDEX_ERRORS view, 2-36, 8-3

CTX_PENDING view, 8-3

CTX_REPORT, 2-41

CTX_THES package

about, 7-2

CTX_USER_INDEX_ERRORS view, 2-36, 8-3

CTX_USER_PENDING view, 8-3

CTXAPP role, 8-2

CTXCAT grammar, 3-18

CTXCAT index, 1-2, 1-14

about, 1-12, 2-10

about performance, 5-19

example, 2-30

ctxkbtc

example, 7-11

ctxload

load thesaurus example, 7-2, 7-8, 7-10

CTXRULE index, 1-2, 1-14

about, 1-12, 2-11

creating, 2-33

CTXSYS user, 8-2

CTXXPATH index

about, 2-11

data storage

index default, 1-12, 2-28

preference example, 2-23

datastore

about, 2-4, 2-21

DATE column, 1-12, 2-28

DBMS_JOB.SUBMIT procedure, 2-40

default thesaurus, 7-4

DEFAULT_INDEX_MEMORY, 5-21

defaults

index, 1-12, 2-28

DETAIL_DATASTORE, 1-8

about, 2-12

diacritical marks

characters with, 2-17

DIRECT_DATASTORE, 1-8

about, 2-12

example, 2-22

DML

view pending, 2-39

DML processing, 1-14

background, 8-5

DML queue, 8-3

document classification, 2-33

about, 1-2

document format

affect on index performance, 5-22

affect on performance, 5-14

document formats

filtering, 2-13

supported, 1-3, 1-9

document hit count

presenting, 1-25

document invalidation, 2-41

document loading

methods, 1-9

document presentation

about, 1-26

document sections, 2-26

document services

about, 1-26

DOMAIN_INDEX_NO_SORT hint

better throughput example, 5-10

drjobdml.sql script, 2-40

DROP INDEX command, 2-36

DROP_STOPLIST procedure, 2-27

dropping an index, 2-36

EQUIV operator, 3-14

errors

DML, 8-3

viewing, 2-36

explain plan, 3-11

extensible query optimizer, 5-2

feedback

query, 3-11

field section

definition, 6-7

nested, 6-8

repeated, 6-8

visible and invisible, 6-7

file paths

storing, 1-8

FILE_DATASTORE, 2-4

about, 1-8, 2-12

example, 2-23

filter

about, 2-4, 2-21

FILTER procedure, 4-3

filtering

custom, 2-13

index default, 1-13, 2-28

to plain text and HTML, 1-26

filtering documents, 2-13

to HTML and plain text, 4-3

FIRST_ROWS hint, 3-19

better response time example, 5-7

better throughput example, 5-10

example, 1-19

format column, 1-8, 2-13

formats

filtering, 2-13

supported, 1-9

fragmentation of index, 2-40, 5-25

viewing, 2-41

full themes

obtaining, 4-5

functional lookup, 5-14

fuzzy matching, 2-18

default, 1-13, 2-29

fuzzy operator, 3-15

garbage collection, 2-41

gist

definition, 4-4

example, 4-5

GIST procedure, 4-5

grammar

CTXCAT, 3-18

grammar CONTEXT, 3-13

granting roles, 8-2

HASPATH operator, 6-14

examples, 6-17

HFEEDBACK procedure, 3-11

HIGHLIGHT procedure, 4-2

highlighting

about, 1-26

overview, 4-2

highlighting text, 4-2

highlighting themes, 4-2

hit count, 3-20

hitlist

presenting, 1-23

HTML

filtering to, 1-26, 4-3

indexing, 2-23, 6-2

indexing example, A-3

searching META tags, 6-10

zone section example, 2-26, 6-10

HTML_SECTION_GROUP object, 2-26, 6-2, 6-10

with NULL_FILTER, 2-23, A-3

IGNORE

format column value, 2-13

index

about, 2-2

creating, 2-21, 2-28

dropping, 2-36

multiple, 2-7

optimizing, 2-40, 2-42

rebuilding, 2-37

structure, 2-2, 2-40

synchronizing, 2-39, 8-5

index defaults

general, 1-12, 2-28

index engine

about, 2-5

index errors

viewing, 2-36

index fragmentation, 2-40, 5-25

index maintenance, 1-14, 2-36

index memory, 5-21

index types

about, 1-11

choosing, 2-9

INDEX_STATS procedure, 2-41

indexed lookup, 5-14

indexing

about, 1-11

bypassing rows, 2-13

considerations, 2-8

limitations, 2-7

overview of process, 2-3

parallel, 2-6, 5-23

resuming failed, 2-37

special characters, 2-15

indexing performance

FAQs, 5-21

parallel, 5-23

indexing time, 5-21

indexing views, 2-7

INPATH operator, 6-14

examples, 6-15

INSERT statement

load text example, 1-9

INSO filter, 5-22

INSO_FILTER, 2-4, 2-13, 2-14

Japanese indexing, 2-18

JAPANESE_LEXER, 2-18

knowledge base

about, 7-12

augmenting, 7-9

linking new terms, 7-10

supported character set, 7-12

user-defined, 7-13

Korean indexing, 2-18

KOREAN_MORP_LEXER, 2-18

language

default setting for indexing, 1-13, 2-29

language specific features, 2-16

languages

indexing, 2-14

language-specific knowledge base, 7-13

lexer

about, 2-5, 2-21

list of themes

definition, 4-4

obtaining, 4-4

loading text

about, 1-6

SQL INSERT example, 1-9

LOB columns

improving query performance, 5-16

indexing, 1-12, 2-28

local partitioned index, 5-18

improved response time, 5-7

location of text, 2-12

logical operators, 3-13

maintaining the index, 2-36

marked-up document

obtaining, 4-3

MARKUP procedure, 4-3

MATCHES

about, 3-5

PL/SQL example, 2-34, 3-6

SQL example, 3-5

MAX_INDEX_MEMORY, 5-21

memory allocation

index synchorization, 5-25

indexing, 5-21

querying, 5-16

META tag

creating zone section for, 6-10

mixed formats

filtering, 2-13

MULTI_COLUMN_DATASTORE, 1-8

about, 2-12

example, 2-22

MULTI_LEXER, 2-15

example, 2-24

multi-language columns

indexing, 2-15

multi-language stoplist

about, 2-27

multiple CONTAINS

improving performance, 5-16

multiple indexes, 2-7

NCLOB column, 1-12, 2-28

NEAR operator, 3-15

nested zone sections, 6-6

NESTED_DATASTORE, 1-8

about, 2-12

NEWS_SECTION_GROUP object, 6-3

NOT operator, 3-14

NULL_FILTER, 2-4

example, 2-23, A-3

NULL_SECTION_GROUP object, 6-2

NUMBER column, 1-12, 2-28

offset information

highlight, 4-2

operators

CATSEARCH, 3-18

CONTAINS, 3-13

logical, 3-13

thesaurus, 7-2

optimizing index, 2-40

example, 2-42

single token, 2-41

optimizing queries, 3-19, 5-2

FAQs, 5-13

response time, 1-19, 5-5

statistics, 5-2

throughput, 5-10

with blocking operations, 5-12

OR operator, 3-14

Oracle Enterprise Manager, 8-6

Oracle9i Text Manager, 8-6

out of line LOB storage

improving performance, 5-16

parallel indexing, 2-6, 5-23

partitioned table, 5-23

parallel queries, 5-11, 5-18

paramstring for CREATE INDEX, 2-28

partitioned index, 5-18

improved response time, 5-7

path section searching, 6-14

PATH_SECTION_GROUP

example, 6-15

pending DML

viewing, 2-39

pending updates, 8-3

performance tuning

indexing, 5-21

querying, 5-13

updating index, 5-25

phrase query, 3-7

plain text

filtering to, 4-3

indexing with NULL_FILTER, 2-23

plain text filtering, 1-26

PL/SQL functions

calling in contains, 3-17

preferences

creating (examples), 2-22

creating with admin tool, 8-6

dropping, 2-37

presenting hitlist, 1-23

printjoins character, 2-15

PROCEDURE_FILTER, 2-13

PSP application, A-2, B-2

query

ABOUT, 3-13

about, 1-18

blocking operations, 5-12

case-sensitive, 3-10

CATSEARCH, 3-4

CONTAINS, 3-2

counting hits, 3-20

MATCHES, 3-5

optimizing for throughput, 5-10

overview, 3-2

parallel, 5-11

query application

prerequisites, 1-4

sample, 1-16

query example, 1-18

query explain plan, 3-11

query expressions, 3-9

query features, 1-20

query feedback, 3-11

query optimization, 3-19

FAQs, 5-13

response time, 5-5

query performance

FAQs, 5-13

query template, 3-15, 3-18

queue

DML, 8-3

rebuilding an index, 2-37

REMOVE_SQE procedure, 3-16

REMOVE_STOPCLASS procedure, 2-27

REMOVE_STOPTHEME procedure, 2-27

REMOVE_STOPWORD procedure, 2-26, 2-27

response time

improving, 5-5

optimizing for, 1-19, 3-19

result buffer size

increasing, 5-12

resuming failed index, 2-37

roles

granting, 8-2

system-defined, 8-2

score

presenting, 1-25

section

attribute, 6-8

field, 6-7

HTML example, 2-26

nested, 6-6

overlapping, 6-6

repeated zone, 6-6

special, 6-9

zone, 6-5

section group

about, 2-21

creating with admin tool, 8-6

section searching

about, 1-20, 6-2

enabling, 6-2

HTML, 6-10

sectioner

about, 2-5

sectioning

automatic, 6-12

path, 6-14

SGA memory allocation, 5-21

single themes

obtaining, 4-5

skipjoins character, 2-15

SORT_AREA_SIZE, 5-12, 5-16, 5-21

special characters

indexing, 2-15

special sections, 6-9

spelling

alternate, 2-17

SQE operator, 3-16

statistics

optimizing with, 5-2

stem operator, 2-18, 3-15

stemming

default, 1-13, 2-29

improving performance, 5-17

stopclass, 2-27

stoplist, 2-26

about, 2-21

creating with admin tool, 8-6

default, 1-13, 2-29

multi-language, 2-20, 2-27

PL/SQL procedures, 2-27

stoptheme, 2-27

about, 2-19

definition, 3-9

stopword, 2-26, 2-27

about, 2-19, 3-8

case-sensitive, 3-10

storage

about, 2-21

STORE_SQE procedure, 3-16

stored query expressions, 3-16

storing text, 2-12

about, 1-8

structure of index, 2-40

structured field searching

about, 1-19

structured fields

presenting in application, 1-25

structured query

example, 2-30

SYN operator, 7-6

SYNC_INDEX procedure, 2-40

synchronizing index, 1-14, 2-39, 8-5

improving performance, 5-25

synonyms

defining, 7-6

template queries, 3-15, 3-18

TEXT

format column value, 2-13

text column

supported types, 1-9

text highlighting, 4-2

Text Manager tool, 8-6

text query applications

about, 1-2

text storage, 2-12

theme capabilities

overview, 1-3

theme functionality

adding, 7-13

theme highlighting, 4-2

theme query, See ABOUT

theme summary

definition, 4-4

themes

indexing, 2-16

THEMES procedure, 4-4

thesaural queries

about, 1-20

thesaurus

about, 7-2

adding to knowledge base, 7-9

case-sensitive, 7-3

DEFAULT, 7-4

default, 7-4

defining terms, 7-6

hierarchical relations, 7-6

loading custom, 7-8

operators, 7-2

supplied, 7-4

using in application, 7-8

thesaurus operator, 3-15

throughput

improving query, 5-10

tildes

indexing characters with, 2-17

TRAIN procedure, 1-2

tuning queries

for response time, 1-19, 5-5

for throughput, 5-10

increasing result buffer size, 5-12

with statistics, 5-2

umlauts

indexing characters with, 2-17

updating index performance

FAQs, 5-25

URL_DATASTORE

about, 2-12

example, 2-23

URLs

storing, 1-8

user

system-defined, 8-2

USER_DATASTORE, 2-7

about, 2-12

USER_FILTER, 2-13

VARCHAR2 column, 1-9

views

indexing, 2-7

wildcard operator, 3-15

improving performance, 5-17

WITHIN operator, 2-26

word query, 3-7

case-sensitivity, 3-10

example, 1-18

wordlist

about, 2-21

XML documents

attribute searching, 6-12

doctype sensitive sections, 6-13

indexing, 6-3

section searching, 6-12

XML_SECTION_GROUP object, 6-3

zone section

definition, 6-5

nested, 6-6

overlapping, 6-6

repeating, 6-6