Oracle Text Application Developer's Guide -- Index

ABOUT query, 3-13

adding for your language, 7-13

case-sensitivity, 3-11

definition, 3-8

example, 1-17

accents

indexing characters with, 2-15

ACCUM operator, 3-14

ADD_STOPCLASS procedure, 2-26

ADD_STOPTHEME procedure, 2-26

ADD_STOPWORD procedure, 2-25, 2-26

ADD_SUB_LEXER procedure

example, 2-23

administration tool, 8-6

ALL_ROWS hint

better response time, 5-6

ALTER INDEX command

rebuilding index, 2-35

resuming failed index, 2-34

alternate spelling, 2-16

AND operator, 3-14

application

sample, A-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-15

BASIC_LEXER, 2-13

BASIC_SECTION_GROUP object, 6-2

BFILE column, 1-7

indexing, 1-10, 2-27

BINARY

format column value, 2-12

BLOB column, 1-7

indexing, 1-10, 2-27

blocking operations

tuning queries with, 5-9

bypassing rows, 2-12

case-sensitive

ABOUT query, 3-11

indexing, 2-15

queries, 3-10

thesaurus, 7-3

CATSEARCH, 3-4

creating index for, 2-30

operators, 3-18

SQL example, 3-4

structured query, 3-5

CHAR column, 1-7

character set

indexing, 2-12

indexing mixed, 2-13

character set column, 1-7

charset column, 2-13

CHARSET_FILTER, 2-5, 2-13

Chinese indexing, 2-17

CHINESE_VGRAM_LEXER, 2-17

CHOOSE hint

better response time, 5-6

CLOB column, 1-7

indexing, 1-10, 2-27

column types

supported for indexing, 1-7

composite words

indexing, 2-16

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 index, 1-2

about, 1-10, 2-9

creating, 1-10, 2-20, 2-27

customizing, 1-11

HTML example, 2-28, A-3

counting hits, 3-21

CREATE INDEX command, 2-27

CREATE_STOPLIST procedure, 2-25, 2-26

CTX_DDL.SYNC_INDEX procedure, 2-37

CTX_DOC package, 4-2

CTX_INDEX_ERRORS view, 2-34, 8-3

CTX_PENDING view, 8-3

CTX_THES package

about, 7-2

CTX_USER_INDEX_ERRORS view, 2-34, 8-3

CTX_USER_PENDING view, 8-3

CTXAPP role, 8-2

CTXCAT index, 1-2, 1-12

about, 1-10, 2-9

example, 2-29

ctxkbtc

example, 7-11

ctxload

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

CTXRULE index, 1-2, 1-12

about, 1-10, 2-10

creating, 2-32

CTXSYS user, 8-2

data storage

index default, 1-10, 2-27

preference example, 2-22

datastore

about, 2-4, 2-20

DATE column, 1-10, 2-27

DBMS_JOB.SUBMIT procedure, 2-37

default thesaurus, 7-4

defaults

index, 1-10, 2-27

DETAIL_DATASTORE, 1-6

about, 2-11

diacritical marks

characters with, 2-15

DIRECT_DATASTORE, 1-6

about, 2-11

example, 2-21

DML

view pending, 2-36

DML processing, 1-12

background, 8-5

DML queue, 8-3

document classification, 2-32

about, 1-2

document formats

filtering, 2-11

supported, 1-3, 1-7

document hit count

presenting, 1-22

document invalidation, 2-38

document loading

methods, 1-8

document presentation

about, 1-23

document sections, 2-25

document services

about, 1-23

DOMAIN_INDEX_NO_SORT hint

better throughput example, 5-8

DOMAIN_INDEX_SORT hint

better response time example, 5-6

drjobdml.sql script, 2-37

DROP INDEX command, 2-34

DROP_STOPLIST procedure, 2-26

dropping an index, 2-34

EQUIV operator, 3-14

errors

DML, 8-3

viewing, 2-34

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

FILE_DATASTORE, 2-4

about, 1-6, 2-11

example, 2-22

filter

about, 2-5, 2-20

FILTER procedure, 4-3

filtering

custom, 2-12

index default, 1-11, 2-27

to plain text and HTML, 1-23

filtering documents, 2-11

to HTML and plain text, 4-3

FIRST_ROWS hint, 3-19

better response time example, 5-5

better throughput example, 5-8

example, 1-17

format column, 1-7, 2-12

formats

filtering, 2-11

supported, 1-7

fragmentation of index, 2-37

full themes

obtaining, 4-5

fuzzy matching, 2-17

default, 1-11, 2-28

fuzzy operator, 3-15

garbage collection, 2-38

gist

definition, 4-4

example, 4-5

GIST procedure, 4-5

granting roles, 8-2

HASPATH operator, 6-14

examples, 6-17

HFEEDBACK procedure, 3-11

HIGHLIGHT procedure, 4-2

highlighting

about, 1-23

overview, 4-2

highlighting text, 4-2

highlighting themes, 4-2

hit count, 3-21

hitlist

presenting, 1-20

HTML

filtering to, 1-23, 4-3

indexing, 2-22, 6-2

indexing example, A-3

searching META tags, 6-10

zone section example, 2-25, 6-10

HTML_SECTION_GROUP object, 2-25, 6-2, 6-10

with NULL_FILTER, 2-22, A-3

IGNORE

format column value, 2-12

index

about, 2-2

creating, 2-20, 2-27

dropping, 2-34

multiple, 2-7

optimizing, 2-37, 2-38

rebuilding, 2-35

structure, 2-2, 2-37

synchronizing, 2-36, 8-5

index defaults

general, 1-10, 2-27

index engine

about, 2-5

index errors

viewing, 2-34

index fragmentation, 2-37

index maintenance, 1-12, 2-34

index types

about, 1-9

choosing, 2-9

indexing

about, 1-9

bypassing rows, 2-12

considerations, 2-8

limitations, 2-7

overview of process, 2-4

parallel, 2-6

resuming failed, 2-34

special characters, 2-13

indexing views, 2-7

INPATH operator, 6-14

examples, 6-15

INSERT statement

load text example, 1-8

INSO_FILTER, 2-5, 2-11, 2-13

Japanese indexing, 2-17

JAPANESE_LEXER, 2-17

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

KOREAN_MORP_LEXER, 2-17

language

default setting for indexing, 1-11, 2-27

language specific features, 2-15

languages

indexing, 2-13

language-specific knowledge base, 7-13

lexer

about, 2-5, 2-20

list of themes

definition, 4-4

obtaining, 4-4

loading text

about, 1-5

SQL INSERT example, 1-8

LOB columns

indexing, 1-10, 2-27

location of text, 2-10

logical operators, 3-13

maintaining the index, 2-34

marked-up document

obtaining, 4-3

MARKUP procedure, 4-3

MATCHES

about, 3-5

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

SQL example, 3-5

META tag

creating zone section for, 6-11

mixed formats

filtering, 2-12

MULTI_COLUMN_DATASTORE, 1-6

about, 2-11

example, 2-21

MULTI_LEXER, 2-13

example, 2-23

multi-language columns

indexing, 2-13

multi-language stoplist

about, 2-26

multiple indexes, 2-7

NCLOB column, 1-10, 2-27

NEAR operator, 3-15

nested zone sections, 6-6

NESTED_DATASTORE, 1-6

about, 2-11

NEWS_SECTION_GROUP object, 6-3

NOT operator, 3-14

NULL_FILTER, 2-5

example, 2-22, A-3

NULL_SECTION_GROUP object, 6-2

NUMBER column, 1-10, 2-27

offset information

highlight, 4-2

operators

CATSEARCH, 3-18

CONTAINS, 3-13

logical, 3-13

thesaurus, 7-2

optimizing index, 2-37

example, 2-38

single token, 2-38

optimizing queries, 3-19, 5-2

response time, 1-17, 5-5

statistics, 5-2

throughput, 5-8

with blocking operations, 5-9

OR operator, 3-14

Oracle Enterprise Manager, 8-6

Oracle9i Text Manager, 8-6

parallel indexing, 2-6

paramstring for CREATE INDEX, 2-27

path section searching, 6-14

PATH_SECTION_GROUP

example, 6-15

pending DML

viewing, 2-36

pending updates, 8-3

phrase query, 3-7

plain text

filtering to, 4-3

indexing with NULL_FILTER, 2-22

plain text filtering, 1-23

PL/SQL functions

calling in contains, 3-16

preferences

creating (examples), 2-21

creating with admin tool, 8-6

dropping, 2-35

presenting hitlist, 1-20

printjoins character, 2-14

PROCEDURE_FILTER, 2-12

PSP application, A-2

query

ABOUT, 3-13

about, 1-16

blocking operations, 5-9

case-sensitive, 3-10

CATSEARCH, 3-4

CONTAINS, 3-2

counting hits, 3-21

MATCHES, 3-5

optimizing for throughput, 5-8

overview, 3-2

query application

prerequisites, 1-4

sample, 1-14

query example, 1-16

query explain plan, 3-11

query expressions, 3-9

query features, 1-18

query feedback, 3-11

query optimization, 3-19

query tuning, 5-5

queue

DML, 8-3

rebuilding an index, 2-35

REMOVE_SQE procedure, 3-16

REMOVE_STOPCLASS procedure, 2-26

REMOVE_STOPTHEME procedure, 2-26

REMOVE_STOPWORD procedure, 2-25, 2-26

response time

improving, 5-5

optimizing for, 1-17, 3-19

result buffer size

increasing, 5-9

resuming failed index, 2-34

roles

granting, 8-2

system-defined, 8-2

score

presenting, 1-22

section

attribute, 6-8

field, 6-7

HTML example, 2-25

nested, 6-6

overlapping, 6-6

repeated zone, 6-6

special, 6-9

zone, 6-5

section group

about, 2-20

creating with admin tool, 8-6

section searching

about, 1-18, 6-2

enabling, 6-2

HTML, 6-10

sectioner

about, 2-5

sectioning

automatic, 6-12

path, 6-14

single themes

obtaining, 4-5

skipjoins character, 2-14

SORT_AREA_SIZE parameter, 5-9

special characters

indexing, 2-13

special sections, 6-9

spelling

alternate, 2-16

SQE operator, 3-15

statistics

optimizing with, 5-2

stem operator, 2-17, 3-15

stemming

default, 1-11, 2-28

stopclass, 2-26

stoplist, 2-25

about, 2-20

creating with admin tool, 8-6

default, 1-11, 2-28

multi-language, 2-18, 2-26

PL/SQL procedures, 2-26

stoptheme, 2-26

about, 2-18

definition, 3-9

stopword, 2-25, 2-26

about, 2-18, 3-8

case-sensitive, 3-10

storage

about, 2-20

STORE_SQE procedure, 3-15, 3-16

stored query expressions, 3-15

storing text, 2-10

about, 1-6

structure of index, 2-37

structured field searching

about, 1-17

structured fields

presenting in application, 1-22

structured query

example, 2-29

SYN operator, 7-6

SYNC_INDEX procedure, 2-37

synchronizing index, 1-12, 2-36, 8-5

synonyms

defining, 7-6

TEXT

format column value, 2-12

text column

supported types, 1-7

text highlighting, 4-2

Text Manager tool, 8-6

text query applications

about, 1-2

text storage, 2-10

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

THEMES procedure, 4-4

thesaural queries

about, 1-18

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

tildes

indexing characters with, 2-15

tuning queries

for response time, 1-17, 5-5

for throughput, 5-8

increasing result buffer size, 5-9

with statistics, 5-2

umlauts

indexing characters with, 2-15

URL_DATASTORE

about, 2-11

example, 2-22

URLs

storing, 1-6

user

system-defined, 8-2

USER_DATASTORE, 2-7

about, 2-11

USER_FILTER, 2-12

VARCHAR2 column, 1-7

views

indexing, 2-7

wildcard operator, 3-15

WITHIN operator, 2-25

word query, 3-7

case-sensitivity, 3-10

example, 1-16

wordlist

about, 2-20

XML documents

attribute searching, 6-12

doctype sensitive sections, 6-13

indexing, 6-3

section searching, 6-12

XML_SECTION_GROUP object, 6-2

zone section

definition, 6-5

nested, 6-6

overlapping, 6-6

repeating, 6-6