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, 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
B
- 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
C
- 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
D
- 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
E
- EQUIV operator, 3-14
- errors
- DML, 8-3
- viewing, 2-34
- explain plan, 3-11
- extensible query optimizer, 5-2
F
- 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
G
- garbage collection, 2-38
- gist
- definition, 4-4
- example, 4-5
- GIST procedure, 4-5
- granting roles, 8-2
H
- 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
I
- 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
J
- Japanese indexing, 2-17
- JAPANESE_LEXER, 2-17
K
- 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
L
- 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
M
- 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
N
- 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
O
- 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
P
- 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
Q
- 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
R
- 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
S
- 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
T
- 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
U
- 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
V
- VARCHAR2 column, 1-7
- views
- indexing, 2-7
W
- wildcard operator, 3-15
- WITHIN operator, 2-25
- word query, 3-7
- case-sensitivity, 3-10
- example, 1-16
- wordlist
- about, 2-20
X
- XML documents
- attribute searching, 6-12
- doctype sensitive sections, 6-13
- indexing, 6-3
- section searching, 6-12
- XML_SECTION_GROUP object, 6-2
Z
- zone section
- definition, 6-5
- nested, 6-6
- overlapping, 6-6
- repeating, 6-6