Skip Headers
Oracle® Text Application Developer's Guide
10g Release 2 (10.2)

Part Number B14217-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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.2
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.6
ALTER INDEX statement
rebuilding index, 3.4.4
resuming failed index, 3.4.3
alternate spelling, 3.2.8.3
alternative grammar, 4.1.18
alternative scoring, 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.5
AUTO_FILTER filter, 3.1.3.2, 3.2.2, 3.2.4, 7.8.4
AUTO_SECTION_GROUP object, 8.1.1.1
automatic sections, 8.3.1

B

background DML, 10.5
base-letter conversion, 3.2.8.2
BASIC_LEXER, 3.2.5
BASIC_SECTION_GROUP object, 8.1.1.1
BFILE column, 3.2.1.1
indexing, 3.3.6.2
BINARY format column value, 3.2.2.2
BLOB column, 3.2.1.1
indexing, 3.3.6.2
blocking operations
tuning queries with, 7.6
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.7.3
operators, 4.3
SQL example, 4.1.2.1
structured query, 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.1
character set column, 3.2.1.6
charset column, 3.2.4.1
CHARSET_FILTER, 3.1.3.2, 3.2.4
Chinese indexing, 3.2.8.5
CHINESE_VGRAM_LEXER, 3.2.8.5
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.6.2
clustering, see unsupervised classification
column types
supported for indexing, 3.2.1.1
composite words
indexing, 3.2.8.4
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.6
HTML example, 2.3, 3.3.6.3, A.2.2
couch, self-tipping, A.1
counting hits, 4.2.10
CREATE INDEX statement, 3.3.5
CREATE TABLE permissions, 11.2.1.7
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, 3.5.2.1
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.7.17
automatic synchronization, 2.4
creating, 2.4
example, 3.3.7
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.8
lexer types, 6.3.2
limitations, 6.3.2
parameters, 6.3.2
CTXSYS user, 10.1
and DBA permissions, 11.2.1.1
and effective user, 11.2.1.3
and procedure ownership, 11.2.1.4
CREATE TABLE permissions, 11.2.1.7
migrating procedures owned by, 11.2.1.2, 11.2.2
preferences, 11.2.1.4
synching and optimizing other indexes, 11.2.1.5, 11.2.1.6
CTXXPATH index, 1.6.3.2
about, 3.1.1

D

data storage
index default, 3.3.6.2
preference example, 3.3.2.1.4
datastore
about, 3.1.3.1, 3.3.1
DATE column, 3.3.6.2
DBA permissions and CTXSYS, 11.2.1.1
DBMS_JOB.SUBMIT procedure, 3.5.2.1
Decision Tree supervised classification, 6.4.1
default thesaurus, 9.1.4
DEFAULT_INDEX_MEMORY, 7.8.2
defaults
index, 3.3.6.2
DESCRIBE_INDEX, 10.4
DETAIL_DATASTORE, 3.2.1.2.1
about, 3.2.1.8
diacritical marks
characters with, 3.2.8.2
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.5
DML queue, 10.2
document
classification, 3.3.8, 6
document format
affect on index performance, 7.8.4
affect on performance, 7.7.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
drjobdml.sql script, 3.5.2.1
DROP INDEX command, 3.4.2
DROP_STOPLIST procedure, 3.3.4.3
dropping an index, 3.4.2

E

effective user, 11.2.1.3
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.6.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
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.9.2
viewing, 3.5.3.5
full themes
obtaining, 5.2.1.2.2
functional lookup, 7.7.6
fuzzy matching, 3.2.9
default, 3.3.6.2
fuzzy operator, 4.2.5

G

garbage collection, 3.5.3.3
German
alternate spelling, 3.2.8.3
composite words, 3.2.8.4
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, 3.3.5
dropping, 3.4.2
getting report on, 10.4
optimizing, 3.5.3, 3.5.3.6
rebuilding, 3.4.4
statistics on, 10.4
structure, 3.1.2, 3.5.3.1
synchronizing, 3.5.2, 10.5
viewing information on, 10.4
index defaults
general, 3.3.6.2
index engine
about, 3.1.3.5
index errors
viewing, 3.4.1
index fragmentation, 3.5.3.2, 7.9.2
index maintenance, 3.4
index memory, 7.8.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.7.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.8.5
resuming failed, 3.4.3
special characters, 3.2.6
indexing performance
FAQs, 7.8
parallel, 7.8.6
indexing time, 7.8.1
INPATH operator, 8.3.4
examples, 8.3.4.2
INSO_FILTER (deprecated), 11.1.1
INSO_OUTPUT_FORMATTING attribute (deprecated), 11.1.1
INSO_TIMEOUT attribute (deprecated), 11.1.1
INSOFILTER directive (deprecated), 11.1.1

J

Japanese indexing, 3.2.8.5
JAPANESE_LEXER, 3.2.8.5
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.5
KOREAN_MORPH_LEXER, 3.2.8.5

L

language
default setting for indexing, 3.3.6.2
language specific features, 3.2.8
languages
indexing, 3.2.5
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.7.11
indexing, 3.3.6.2
local partitioned index, 7.7.14
improved response time, 7.2.3
location of text, 3.2.1
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.8.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.8.2
MDATA operator, 8.1.2.4
MDATA section, 8.1.2.4
memory allocation
index synchronization, 7.9.3
indexing, 7.8.2
querying, 7.7.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
migrating procedures, 11.2.1.2
migrating to previous releases, 11.2.2
mixed formats
filtering, 3.2.2.2
mixed query, 8.1.2.4
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.7.12
MVIEW see materialized views

N

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

O

offset information
highlight, 5.1.3.2
operator
MDATA, 8.1.2.4
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.7
response time, 7.2
statistics, 7.1
throughput, 7.3
with blocking operations, 7.6
OR operator, 4.2.2
ora
contains, 1.6.2
Oracle Enterprise Manager, 10.6
Oracle XML DB, 1.6
Oracle9i Text Manager, 10.6
out of line LOB storage
improving performance, 7.7.11

P

parallel indexing, 3.1.6, 7.8.5
partitioned table, 7.8.6
parallel queries, 7.5, 7.7.15
paramstring for CREATE INDEX, 3.3.5
partitioned index, 7.7.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.8
querying, 7.7
updating index, 7.9
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
preferences
and CTXSYS, 11.2.1.4
creating (examples), 3.3.2
creating with admin tool, 10.6
dropping, 3.4.5
previous releases, migrating from, 11
previous releases, migrating to, 11.2.2
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.6
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
optimizing for throughput, 7.3
overview, 4.1
parallel, 7.5
speeding up with MDATA, 8.1.2.4
viewing information on, 10.4
viewing log of, 10.4
query analysis, 4.1.19
query application
example, 2.3
sample, 1.3.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.7
response time, 7.2
query performance
FAQs, 7.7
query relaxation, 4.1.15
query rewrite, 4.1.14
query template, 4.2.6, 4.3.1
QUERY_LOG_SUMMARY, 10.4
queue
DML, 10.2

R

rebuilding an index, 3.4.4
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.6
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
searching
XML, 1.6
section
attribute, 8.1.2.5
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
special, 8.1.2.6
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.6
section searching
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
security improvements in current release, 11.2.1
self-tipping couch, A.1
SGA memory allocation, 7.8.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.6, 7.7.10, 7.8.2
special characters
indexing, 3.2.6
special sections, 8.1.2.6
spelling
alternate, 3.2.8.3
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.6.2
improving performance, 7.7.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.6
default, 3.3.6.2
multi-language, 3.2.12.1, 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 expressions, 4.2.7
storing text, 3.2.1
about, 3.2.1.2
structure of index, 3.5.3.1
structured query
example, 3.3.7
supervised classification, 6.4
Decision Tree, 6.4.1
SVM supervised classification, 6.4.2
memory requirements, 6.4.2
SYN operator, 9.2.1
SYNC_INDEX procedure, 2.3, 3.5.2.1
synching and optimizing other indexes, 11.2.1.5, 11.2.1.6
synchronize index, 2.3
synchronizing index, 3.5.2, 10.5
improving performance, 7.9
synonyms
defining, 9.2.1

T

talking pillow, A.1
template queries, 4.2.6, 4.3.1
text column
supported types, 3.2.1.1
TEXT format column value, 3.2.2.2
text highlighting, 5.1.1
Text Manager tool, 10.6
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.1
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.2
TOKEN_INFO, 10.4
TOKEN_TYPE, 10.4
tracing, 7.4
TRAIN procedure, 6.4
tuning queries
for response time, 7.2
for throughput, 7.3
increasing result buffer size, 7.6
with statistics, 7.1

U

umlauts
indexing characters with, 3.2.8.2
unsupervised classification, 6.5
updating index performance
FAQs, 7.9
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.7.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.6
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.6
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