Skip Headers
Oracle® Text Application Developer's Guide
11g Release 1 (11.1)

Part Number B28303-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
Contact Us

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.3
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.5
ALTER INDEX statement
rebuilding index, 3.4.5
resuming failed index, 3.4.3
alternate spelling, 3.2.8.4
alternative grammar, 4.1.18
alternative grammar template, 4.1.18
alternative scoring, 4.1.17
alternative scoring template, 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.6
AUTO_FILTER filter, 3.1.3.2, 3.2.2, 3.2.4, 7.9.4
AUTO_LEXER
indexing columns and, 3.2.5
language detection and, 3.2.4.2
AUTO_LEXER lexer type, 3.2.8.1
AUTO_LEXER with fuzzy matching and stemming, 3.2.9
AUTO_SECTION_GROUP object, 8.1.1.1
automatic sections, 8.3.1

B

background DML, 10.6
base-letter conversion, 3.2.8.3
BASIC_LEXER, 3.2.5
BASIC_SECTION_GROUP object, 8.1.1.1
BFILE column, 3.2.1.1
indexing, 3.3.5.2
BINARY format column value, 3.2.2.2
BLOB column, 3.2.1.1
indexing, 3.3.5.2
blocking operations
tuning queries with, 7.7
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.6.3
operators, 4.3
SQL example, 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.3
character set column, 3.2.1.6
charset column, 3.2.4.3
CHARSET_FILTER, 3.1.3.2, 3.2.4
Chinese indexing, 3.2.8.6
CHINESE_VGRAM_LEXER, 3.2.8.6
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.5.2
clustering, see unsupervised classification
column types
supported for indexing, 3.2.1.1
composite words
indexing, 3.2.8.5
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.5
HTML example, 2.3, 3.3.5.5, A.2.2
couch, self-tipping, A.1
counting hits, 4.2.10
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
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.8.17
automatic synchronization, 2.4
creating, 2.4
example, 3.3.6
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.7
lexer types, 6.3.2
limitations, 6.3.2
parameters, 6.3.2
CTXSYS user, 10.1
CTXXPATH index, 1.5.3.2
about, 3.1.1

D

data storage
index default, 3.3.5.2
preference example, 3.3.2.1.4
datastore
about, 3.1.3.1, 3.3.1
DATE column, 3.3.5.2
Decision Tree supervised classification, 6.4.1
default thesaurus, 9.1.4
DEFAULT_INDEX_MEMORY, 7.9.2
defaults
index, 3.3.5.2
DEFINEMERGE operator, 4.2.11
DEFINESCORE operator, 4.2.11
DESCRIBE_INDEX, 10.4
DETAIL_DATASTORE, 3.2.1.2.1
about, 3.2.1.8
diacritical marks
characters with, 3.2.8.3
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.6
DML queue, 10.2
document
classification, 3.3.7, 6
document format
affect on index performance, 7.9.4
affect on performance, 7.8.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
DROP INDEX statement, 3.4.2
DROP_STOPLIST procedure, 3.3.4.3
dropping an index, 3.4.2

E

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.5.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
FIRST_ROWS(n) hint, 7.2.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.10.2
viewing, 3.5.3.5
full themes
obtaining, 5.2.1.2.2
functional lookup, 7.8.6
fuzzy matching, 3.2.9
default, 3.3.5.2
fuzzy operator, 4.2.5

G

garbage collection, 3.5.3.3
German
alternate spelling, 3.2.8.4
composite words, 3.2.8.5
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
dropping, 3.4.2
fragmentation, 3.5.3.2
getting report on, 10.4
incrementally creating, 3.3.5.3
maintenance, 3.4
online recreation, 3.4.4.1
optimizing, 3.5.3, 3.5.3.6
rebuilding, 3.4.5
statistics on, 10.4
structure, 3.1.2, 3.5.3.1
synchronizing, 3.5.2, 10.6
viewing information on, 10.4
index defaults
general, 3.3.5.2
index engine
about, 3.1.3.5
index errors
viewing, 3.4.1
index fragmentation, 7.10.2
index memory, 7.9.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.8.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.9.5
resuming failed, 3.4.3
special characters, 3.2.6
indexing performance
FAQs, 7.9
parallel, 7.9.6
indexing time, 7.9.1
INPATH operator, 8.3.4
examples, 8.3.4.2
INSO_FILTER (deprecated), 11.2.1
INSO_OUTPUT_FORMATTING attribute (deprecated), 11.2.1
INSO_TIMEOUT attribute (deprecated), 11.2.1
INSOFILTER directive (deprecated), 11.2.1

J

Japanese indexing, 3.2.8.6
JAPANESE_LEXER, 3.2.8.6
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.6
KOREAN_MORPH_LEXER, 3.2.8.6

L

language
default setting for indexing, 3.3.5.2
language detection
AUTO_LEXER, 3.2.8.1
language specific features, 3.2.8
languages
indexing, 3.2.5
language-specific feature
AUTO_LEXER, 3.2.8.1
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.8.11
indexing, 3.3.5.2
local partitioned index, 7.8.14
improved response time, 7.2.3
location of text, 3.2.1
locking parameter for sync_index, 3.5.2.3
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.7.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.9.2
maxtime parameter for sync_index, 3.5.2.2
MDATA operator, 8.1.2.4
MDATA section, 8.1.2.4
memory allocation
index synchronization, 7.10.3
indexing, 7.9.2
querying, 7.8.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
mixed formats
filtering, 3.2.2.2
mixed query, 8.1.2.4, 8.1.2.5
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.8.12
MVIEW see materialized views

N

NCLOB column, 3.3.5.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
NOPOPULATE keyword
and incremental rebuild,and replace parameter, 3.3.5.3
nopopulate with RECREATE_INDEX_ONLINE, 3.4.4.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.5.2

O

offset information
highlight, 5.1.3.2
online
recreating a CONTEXT indextype, 3.4.4.1
operator
MDATA, 8.1.2.4
SDATA, 8.1.2.5
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.8
response time, 7.2
statistics, 7.1
throughput, 7.3
with blocking operations, 7.7
OR operator, 4.2.2
ora
contains, 1.5.2
Oracle Enterprise Manager, 10.5
Oracle Enterprise Manager and Oracle Text, 10.5
Oracle Text pages in OEM, 10.5
Oracle XML DB, 1.5
out of line LOB storage
improving performance, 7.8.11

P

parallel indexing, 3.1.6, 7.9.5
partitioned table, 7.9.6
parallel queries, 7.6, 7.8.15
across Real Application Clusters (RAC) nodes, 7.6
partitioned index, 7.8.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.9
querying, 7.8
updating index, 7.10
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
POPULATE_PENDING, 3.3.5.4
preferences
creating (examples), 3.3.2
creating with admin tool, 10.5
dropping, 3.4.6
previous releases, migrating from, 11
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.7
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, 8.1.2.5
optimizing for throughput, 7.3
overview, 4.1
parallel, 7.6
speeding up with MDATA, 8.1.2.4
speeding up with SDATA, 8.1.2.5
viewing information on, 10.4
viewing log of, 10.4
query analysis, 4.1.19
query application
example, 2.3
sample, 1.2.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.8
response time, 7.2
Query Parallelized Across Oracle RAC Nodes, 7.6.2
query performance
FAQs, 7.8
query relaxation, 4.1.15
query relaxation template, 4.1.15
query rewrite, 4.1.14
query rewrite template, 4.1.14
query template, 4.2.6, 4.3.1
lang parameter and, 4.1.16
Query Templates, 4.1.13
QUERY_LOG_SUMMARY, 10.4
queue
DML, 10.2

R

Real Application Clusters (RAC) and parallel queries, 7.6
rebuilding an index, 3.4.5, 3.4.5
RECREATE_INDEX_ONLINE, 3.4.4.1
and DML, 3.4.4.1
recreating a local partitioned index online, 3.4.4.1
recreating an index, 3.4.4
recreating an index online, 3.4.4.1
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.7
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
SDATA operator, 8.1.2.5
SDATA section, 8.1.2.5
searching
XML, 1.5
section
attribute, 8.1.2.6
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
SDATA, 8.1.2.5
special, 8.1.2.7
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.5
section searching, 4.2.3
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
self-tipping couch, A.1
SGA memory allocation, 7.9.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.7, 7.8.10, 7.9.2
special characters
indexing, 3.2.6
special sections, 8.1.2.7
spelling
alternate, 3.2.8.4
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.5.2
improving performance, 7.8.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.5
default, 3.3.5.2
multi-language, 3.2.12.2, 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 expression, defining, 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 data
adding, 8.1.2.5
removing, 8.1.2.5
section, 8.1.2.5
structured query
example, 3.3.6
supervised classification, 6.4
Decision Tree, 6.4.1
SVM supervised classification, 6.4.2
memory requirements, 6.4.2
swap and noswap with RECREATE_INDEX_ONLINE, 3.4.4.1
SYN operator, 9.2.1
sync_index locking parameter, 3.5.2.3
sync_index maxtime parameter, 3.5.2.2
SYNC_INDEX procedure, 2.3
synchronize index, 2.3
synchronizing index, 3.5.2, 10.6
improving performance, 7.10
synonyms
defining, 9.2.1

T

talking pillow, A.1
template queries, 4.2.6, 4.3.1
templates, 4.1.13
query rewrite, 4.1.14
text column
supported types, 3.2.1.1
TEXT format column value, 3.2.2.2
text highlighting, 5.1.1
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.2
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.3
TOKEN_INFO, 10.4
TOKEN_TYPE, 10.4
tracing, 7.5
TRAIN procedure, 6.4
tuning queries
for response time, 7.2
for throughput, 7.3
increasing result buffer size, 7.7
with statistics, 7.1

U

umlauts
indexing characters with, 3.2.8.3
unsupervised classification, 6.5
updating index performance
FAQs, 7.10
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.8.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.5
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.5
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