321/321
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 operator
[1]
,
[2]
ABOUT query
adding for your language
[1]
case-sensitivity
[1]
definition
[1]
accents
indexing characters with
[1]
ADD_SUB_LEXER procedure
example
[1]
administration tool
[1]
all-at-once swap
[1]
ALTER INDEX statement
rebuilding index
[1]
alternate_spelling attribute
[1]
alternate spelling
[1]
alternative grammar
[1]
alternative grammar template
[1]
alternative scoring
[1]
alternative scoring template
[1]
application
sample
[1]
,
[2]
applications, updating
[1]
attribute
searching XML
[1]
attribute sections
[1]
auction table schema example
[1]
AUTO_FILTER filter
[1]
AUTO_LEXER with fuzzy matching and stemming
[1]
AUTO keyword
character sets and
[1]
AUTOMATIC keyword
character sets and
[1]
automatic sections
[1]
B
background DML
[1]
base_letter attribute
[1]
base-letter conversion
[1]
BASIC_LEXER preference type
[1]
BFILE column
indexing
[1]
BIG_IO index option
[1]
BINARY format column value
[1]
BLOB column
indexing
[1]
blocking operations
tuning queries with
[1]
b-tree index
[1]
bypassing rows
[1]
C
cantaloupe dispenser
[1]
case-insensitive queries
[1]
case-sensitive
ABOUT query
[1]
indexing
[1]
queries
[1]
thesaurus
[1]
catalog application
example
[1]
catalog information application
flowchart
[1]
catalog table relationships
[1]
CATSEARCH
operators
[1]
SQL example
[1]
CATSEARCH operator
[1]
,
[2]
CATSEARCH queries
[1]
Character Large Object (CLOB)
[1]
character set
detection
[1]
indexing
[1]
indexing mixed
[1]
character set column
[1]
CHAR column
[1]
charset column
[1]
Chinese indexing
[1]
classification
Decision Tree (supervised)
[1]
rule-based
[1]
simple, see rule-based classification
[1]
supervised
[1]
SVM (supervised)
[1]
unsupervised
[1]
classification application
creating
[1]
example
[1]
overview illustration
[1]
CLOB (Character Large Object) datatype
[1]
CLOB column
indexing
[1]
CLOB datatype
[1]
clustering, see unsupervised classification
[1]
clustering with classification
[1]
column types
supported for indexing
[1]
column types that cannot be indexed
[1]
combined catalog index
[1]
composite attribute
[1]
composite words
indexing
[1]
concordance
[1]
CONNECT role
[1]
CONTAINS
operators
[1]
PL/SQL example
[1]
query
[1]
SQL example
[1]
structured query
[1]
CONTAINS operator
XML search applications and
[1]
CONTAINS query
[1]
CONTEXT data storage
[1]
CONTEXT grammar
[1]
CONTEXT index
creating
[1]
,
[2]
HTML example
[1]
,
[2]
,
[3]
structure
[1]
XML search applications and
[1]
continuation
[1]
cost for indexing
[1]
couch, self-tipping
[1]
counting hits
[1]
CREATE_INDEX_SCRIPT
[1]
CREATE_POLICY_SCRIPT
[1]
CREATE INDEX statement
[1]
CTX_CLS.TRAIN procedure
[1]
CTX_DDL.ADD_STOPWORD procedure
[1]
CTX_DDL.CREATE_STOPLIST procedure
[1]
CTX_DDL.EXCHANGE_SHADOW_INDEX procedure
[1]
CTX_DDL.MAXTIME_UNLIMITED procedure
[1]
CTX_DDL.POPULATE_PENDING procedure
[1]
CTX_DDL.SYNC_INDEX procedure
[1]
,
[3]
,
[4]
CTX_DDL package
[1]
CTX_DOC.MARKUP procedure
[1]
CTX_DOC.POLICY_SNIPPET procedure
[1]
CTX_DOC.SNIPPET procedure
[1]
CTX_DOC package
[1]
CTX_FILTER_CACHE_STATISTICS view
[1]
CTX_INDEX_ERRORS view
[1]
,
[2]
CTX_PENDING view
[1]
CTX_QUERY.RESULT_SET procedure
[1]
CTX_REPORT
[1]
CTX_REPORT_TOKEN_TYPE
[1]
CTX_REPORT.CREATE_INDEX_SCRIPT
[1]
CTX_REPORT.CREATE_POLICY_SCRIPT
[1]
CTX_REPORT.DESCRIBE_INDEX
[1]
CTX_REPORT.DESCRIBE_POLICY
[1]
CTX_REPORT.INDEX_SIZE
[1]
CTX_REPORT.INDEX_STATS
[1]
CTX_REPORT.QUERY_LOG_SUMMARY
[1]
CTX_REPORT.TOKEN_INFO
[1]
CTX_REPORT package
[1]
CTX_THES.IMPORT_THESAURUS
load thesaurus example
[1]
CTX_THES package
about
[1]
CTX_USER_INDEX_ERRORS view
[1]
,
[2]
CTX_USER_PENDING view
[1]
CTXAPP role
granting
[1]
CTXCAT data storage
[1]
CTXCAT grammar
[1]
CTXCAT index
about performance
[1]
automatic synchronization
[1]
example
[1]
sub-index
[1]
CTXFILTERCACHE operator
[1]
ctxkbtc
example
[1]
ctxload
load thesaurus example
[1]
,
[2]
,
[3]
CTXRULE index
allowable queries
[1]
creating
[1]
lexer types
[1]
limitations
[1]
parameters
[1]
CTXSYS.AUTO_FILTER filter type
[1]
CTXSYS user
[1]
custom CONTEXT index example
[1]
custom filtering
[1]
D
data staging
[1]
data storage
CONTEXT data
[1]
CTXCAT data
[1]
index default
[1]
preference example
[1]
datastore
about
[1]
,
[2]
DATASTORE types
summary of
[1]
DATE column
[1]
Decision Tree supervised classification
[1]
decreasing indexing time
[1]
DEFAULT_INDEX_MEMORY
[1]
defaults
index
[1]
default thesaurus
[1]
DEFINEMERGE operator
[1]
DEFINESCORE operator
[1]
degree of parallelism
[1]
DESCRIBE_INDEX
[1]
diacritical marks
characters with
[1]
DIRECT_DATASTORE
example
[1]
DML
view pending
[1]
DML processing
background
[1]
DML queue
[1]
document
classification
[1]
,
[2]
document classification application
overview illustration
[1]
document collections
[1]
document filtering
[1]
document format
affect on index performance
[1]
affect on performance
[1]
document formats
filtering
[1]
supported
[1]
document invalidation
[1]
document presentation
about
[1]
document section
searching
[1]
document sections
[1]
document services
about
[1]
document theme
[1]
,
[2]
DOMAIN_INDEX_NO_SORT hint
better throughput example
[1]
DOMAIN_INDEX_SORT hint
better response time example
[1]
domain index
[1]
doubly-truncated query
[1]
drop index example
[1]
dropping an index
[1]
E
endjoin
[1]
entity extraction
[1]
errors
DML
[1]
viewing
[1]
EXCHANGE_SHADOW_INDEX procedure
[1]
execute privileges
granting
[1]
explain plan
[1]
F
failed index
resuming
[1]
FAST mode
[1]
feedback
query
[1]
field section
definition
[1]
nested
[1]
repeated
[1]
visible and invisible
[1]
filter
about
[1]
,
[2]
filtering
custom
[1]
index default
[1]
to plain text and HTML
[1]
filtering documents
[1]
FIRST_ROWS(n) hint
[1]
FIRST_ROWS hint
better throughput example
[1]
flowchart of a simple query application
[1]
format column
[1]
,
[2]
,
[3]
formats
filtering
[1]
supported
[1]
forward_index attribute
[1]
forward index
[1]
fragmentation of index
viewing
[1]
FULL mode
[1]
full themes
obtaining
[1]
functional lookup
[1]
fuzzy matching
default
[1]
fuzzy operator
[1]
G
garbage collection
[1]
German
alternate spelling
[1]
composite words
[1]
gist
definition
[1]
example
[1]
grammar
alternative
[1]
CTXCAT
[1]
grammar CONTEXT
[1]
granting roles
[1]
H
HASPATH operator
[1]
HASPATH operators
examples
[1]
highlighting
about
[1]
overview
[1]
highlighting documents
[1]
highlighting text
[1]
highlighting themes
[1]
hit count
[1]
home air dirtier
[1]
HTML
filtering to
[1]
indexing
[1]
indexing example
[1]
,
[2]
searching META tags
[1]
zone section example
[1]
,
[2]
HTML_SECTION_GROUP object
with NULL_FILTER
[1]
,
[2]
,
[3]
HTML_SECTION_GROUP type
[1]
HTML section example
[1]
I
IGNORE
format column value
[1]
IGNORE format column type
[1]
IGNORE format column value
[1]
IGNORE value
[1]
incremental indexing
[1]
index
about
[1]
creating
[1]
dropping
[1]
fragmentation
[1]
getting report on
[1]
incrementally creating
[1]
maintenance
[1]
online recreation
[1]
optimizing
[1]
,
[2]
rebuilding
[1]
statistics on
[1]
structure
[1]
,
[2]
synchronizing
[1]
,
[2]
viewing information on
[1]
INDEX_SIZE
[1]
INDEX_STATS
[1]
INDEX_STATS procedure
[1]
index_themes attribute
[1]
index defaults
general
[1]
indexed lookup
[1]
index engine
about
[1]
index errors
viewing
[1]
index fragmentation
reducing
[1]
indexing
bypassing rows
[1]
considerations
[1]
languages
[1]
overview of process
[1]
parallel
[1]
,
[2]
resuming failed
[1]
special characters
[1]
views and
[1]
indexing HTML
[1]
indexing performance
FAQs
[1]
parallel
[1]
indexing plain text
[1]
indexing time
decreasing
[1]
index memory
[1]
index synchronization
[1]
index types
choosing
[1]
init.ora setting
[1]
INPATH operator
examples
[1]
INSERT statement
example
[1]
INSO_FILTER (deprecated)
[1]
INSO_OUTPUT_FORMATTING attribute (deprecated)
[1]
INSO_TIMEOUT attribute (deprecated)
[1]
INSOFILTER directive (deprecated)
[1]
inverted index
[1]
J
JA16EUC character set
[1]
JA16SJIS character set
[1]
Japanese indexing
[1]
Jdeveloper
Text wizard
[1]
,
[2]
K
knowledge base
about
[1]
augmenting
[1]
linking new terms
[1]
user-defined
[1]
Korean indexing
[1]
L
language
default setting for indexing
[1]
languages
indexing
[1]
language specific features
[1]
language-specific knowledge base
[1]
left-truncated query
[1]
lexer
about
[1]
,
[2]
and CTXRULE
[1]
list of themes
definition
[1]
obtaining
[1]
loading text
about
[1]
LOB columns
improving query performance
[1]
indexing
[1]
LOB column storage
[1]
local partitioned index
improved response time
[1]
location of text
[1]
locked base table
[1]
locking parameter for sync_index
[1]
logical operators
[1]
low information words
[1]
M
magnet, pet see pet magnet
[1]
maintaining the index
[1]
mapping table
forward index and
[1]
marked-up document
obtaining
[1]
MARKUP procedure
[1]
MATCHES
about
[1]
PL/SQL example
[1]
SQL example
[1]
MATCHES operator
classifying with
[1]
materialized views, indexes on
[1]
MAX_INDEX_MEMORY
[1]
maxtime parameter for sync_index
[1]
MDATA operators
[1]
MDATA section
[1]
memory allocation
indexing
[1]
index synchronization
[1]
querying
[1]
merged word and theme index
[1]
metadata
adding
[1]
removing
[1]
section
[1]
META tag
creating zone section for
[1]
Microsoft Word support
[1]
,
[2]
migrating from previous releases
[1]
mixed_case attribute
[1]
mixed character set columns
[1]
mixed character sets
[1]
mixed-format column
[1]
mixed formats
filtering
[1]
mixed query
[1]
,
[2]
mixed query performance
[1]
MULTI_COLUMN_DATASTORE
example
[1]
MULTI_LEXER
example
[1]
MULTI_LEXER preference type
[1]
multi-language columns
indexing
[1]
multi-language stoplist
about
[1]
multiple CONTAINS
improving performance
[1]
MVIEW see materialized views
[1]
N
name matching
See:
name search
name search
examples using NDATA sections
[1]
NCLOB column
[1]
NDATA sections
in name search example
[1]
NEAR_ACCUM operator
[1]
NEAR operator
[1]
nested zone sections
[1]
NOPOPULATE keyword
incremental rebuild and
[1]
replace parameter and
[1]
nopopulate with RECREATE_INDEX_ONLINE
[1]
NULL_FILTER
example
[1]
,
[2]
,
[3]
NULL_FILTER filter type
[1]
NULL_FILTER preference type
[1]
NULL maxtime
[1]
NUMBER column
[1]
number tokenization
[1]
O
offset information
highlight
[1]
online
recreating a CONTEXT indextype
[1]
online index
[1]
ONLINE parameter
[1]
operators
CATSEARCH
[1]
CONTAINS
[1]
logical
[1]
MDATA
[1]
SDATA
[1]
thesaurus
[1]
optimizing index
example
[1]
single token
[1]
optimizing queries
FAQs
[1]
response time
[1]
throughput
[1]
with blocking operations
[1]
Oracle Enterprise Manager
[1]
Oracle Enterprise Manager and Oracle Text
[1]
Oracle Text pages in OEM
[1]
Oracle Text user
creating
[1]
Oracle XML DB
[1]
out of line LOB storage
improving performance
[1]
P
parallel indexing
partitioned table
[1]
parallel queries
across Real Application Clusters (RAC) nodes
[1]
paramstring string
[1]
partitioned index
improved response time
[1]
partitioned table
querying
[1]
partitions limit
[1]
PATH_SECTION_GROUP
example
[1]
path section searching
[1]
PDF support
[1]
,
[2]
pending DML
viewing
[1]
pending queue
[1]
pending updates
[1]
performance
[1]
performance tuning
indexing
[1]
querying
[1]
updating index
[1]
per-partition swap
[1]
pet magnet
gist
[1]
illustration
[1]
themes
[1]
phrase query
[1]
pizza shredder
[1]
PL/SQL functions
calling in contains
[1]
plain text
indexing with NULL_FILTER
[1]
plain text filtering
[1]
PLAINTEXT value
[1]
POPULATE_PENDING procedure
[1]
POPULATE keyword
[1]
preferences
creating (examples)
[1]
creating with admin tool
[1]
dropping
[1]
prefix indexing example
[1]
previous releases, migrating from
[1]
printjoin character
[1]
printjoin characters example
[1]
PROCEDURE_FILTER example
[1]
PSP application
[1]
,
[2]
punctuation identification
[1]
Q
query
ABOUT
[1]
analysis
[1]
blocking operations
[1]
case-sensitive
[1]
,
[2]
CATSEARCH
[1]
,
[2]
CONTAINS
[1]
counting hits
[1]
CTXRULE
[1]
getting report on
[1]
log
[1]
MATCHES
[1]
mixed
[1]
,
[2]
optimizing for throughput
[1]
overview
[1]
parallel
[1]
speeding up with MDATA
[1]
speeding up with SDATA
[1]
viewing information on
[1]
viewing log of
[1]
query_filter_cache_size basic storage attribute
[1]
QUERY_LOG_SUMMARY
[1]
query analysis
[1]
query application
example
[1]
flowchart
[1]
sample
[1]
query explain plan
[1]
query expressions
[1]
query features
[1]
query feedback
[1]
query language
[1]
query log
[1]
,
[2]
query optimization
FAQs
[1]
response time
[1]
Query Parallelized Across Oracle RAC Nodes
[1]
query performance
FAQs
[1]
query processing with FILTER BY and ORDER BY example
[1]
query relaxation
[1]
query relaxation template
[1]
query rewrite
[1]
query rewrite template
[1]
query template
lang parameter and
[1]
Query Templates
[1]
queue
DML
[1]
R
Real Application Clusters (RAC) and parallel queries
[1]
rebuilding an index
[1]
RECREATE_INDEX_ONLINE
and DML
[1]
RECREATE_INDEX_ONLINE procedure
no populate with
[1]
swap and noswap with
[1]
recreating a local partitioned index online
[1]
recreating an index
[1]
recreating an index online
[1]
relaxing queries
[1]
remote LOB column
[1]
RESOURCE role
[1]
response time
improving
[1]
optimizing for
[1]
result buffer size
increasing
[1]
result set interface
[1]
result sets
[1]
resuming failed index
[1]
rewriting queries
[1]
right-truncated query
[1]
roles
granting
[1]
system-defined
[1]
rowid
[1]
rule-based classification
[1]
,
[2]
,
[3]
rules
about for simple classification
[1]
rule table
creating
[1]
S
sample application
[1]
,
[2]
save_copy attribute
[1]
scheduled swap
[1]
scheduling local index re-creation with all-at-once swap
[1]
scoring
alternative
[1]
SDATA operators
[1]
SDATA section
[1]
searching
XML
[1]
section
attribute
[1]
field
[1]
groups and types
[1]
,
[2]
HTML example
[1]
MDATA
[1]
nested
[1]
overlapping
[1]
repeated zone
[1]
SDATA
[1]
special
[1]
stop section
[1]
types and groups
[1]
,
[2]
zone
[1]
sectioner
about
[1]
section group
about
[1]
and section types
[1]
,
[2]
creating with admin tool
[1]
sectioning
automatic
[1]
path
[1]
section searching
about
[1]
,
[2]
enabling
[1]
HTML
[1]
See also rule-based classification
[1]
See also simple classification
[1]
SELECT statement
with CONTAINS
[1]
self-tipping couch
[1]
SEPARATE_OFFSETS index option
[1]
,
[2]
SGA memory allocation
[1]
simple classification
rules and
[1]
simple classification, see rule-based classification
[1]
single themes
obtaining
[1]
size of index, viewing
[1]
skipjoin character
[1]
SORT_AREA_SIZE
[1]
,
[2]
,
[3]
special characters
indexing
[1]
special sections
[1]
spelling
alternate
[1]
searching different
[1]
SQE operator
[1]
SQL*Loader
[1]
,
[2]
SQL CONTAINS operator
[1]
startjoin
[1]
stemming
default
[1]
improving performance
[1]
stem operator
[1]
,
[2]
stopclass
[1]
stoplist
about
[1]
creating with admin tool
[1]
default
[1]
multi-language
[1]
,
[2]
PL/SQL procedures for
[1]
stop section
[1]
stoptheme
about
[1]
definition
[1]
stopword
about
[1]
,
[2]
case-sensitive
[1]
storage
about
[1]
stored query expression, defining
[1]
stored query expressions
[1]
storing
file path names
[1]
structured document information
[1]
storing text
about
[1]
different methods illustration
[1]
structure
CONTEXT index
[1]
structured data
adding
[1]
removing
[1]
section
[1]
structured query
example
[1]
structured query clause
[1]
structure of index
[1]
sub-index
[1]
substring indexing example
[1]
supervised classification
Decision Tree
[1]
SVM supervised classification
memory requirements
[1]
swap and noswap with RECREATE_INDEX_ONLINE
[1]
sync_index locking parameter
[1]
sync_index maxtime parameter
[1]
SYNC_INDEX procedure
[1]
,
[2]
synchronization
[1]
synchronize index
[1]
synchronizing index
improving performance
[1]
synonyms
defining
[1]
SYN operator
[1]
T
talking pillow
[1]
template queries
[1]
,
[2]
templates
query rewrite
[1]
text column
supported types
[1]
TEXT format column value
[1]
text fragments
[1]
text highlighting
[1]
Text-on-XML Method
[1]
text storage
[1]
that stopword
[1]
theme functionality
adding
[1]
theme highlighting
[1]
themes
indexing
[1]
theme summary
definition
[1]
thesaural queries
about
[1]
thesaurus
about
[1]
adding to knowledge base
[1]
case-sensitive
[1]
default
[1]
DEFAULT
[1]
defining terms
[1]
hierarchical relations
[1]
loading custom
[1]
operators
[1]
supplied
[1]
using in application
[1]
thesaurus operator
[1]
this stopword
[1]
throughput
improving query
[1]
tildes
indexing characters with
[1]
time limit
setting for synchronizing
[1]
TOKEN_INFO
[1]
TOKEN_TYPE
[1]
tokenization behavior
[1]
tokenizing
[1]
token prefix
[1]
tokens
[1]
token separation
[1]
tracing
[1]
TRAIN procedure
[1]
transactional
[1]
,
[2]
,
[3]
Transparent Data Encryption
enabled column and,enabled tablespace and
[1]
tuning queries
for response time
[1]
for throughput
[1]
increasing result buffer size
[1]
U
umlauts
indexing characters with
[1]
unsupervised classification
[1]
updating index performance
FAQs
[1]
updating your applications
[1]
URLs
storing
[1]
user
creating Oracle Text
[1]
system-defined
[1]
USER_LEXER preference type
[1]
user-defined lexer interface
[1]
V
VARCHAR2 column
[1]
viewing information on indexes and queries
[1]
viewing size of index
[1]
views
indexing and
[1]
materialized
[1]
W
WHERE clause
[1]
whitespace
[1]
whitespace-delimited language
[1]
wildcard operator
improving performance
[1]
wildcard queries
[1]
WITHIN operator
[1]
wizard
Oracle Text addin
[1]
,
[2]
word continuation
[1]
wordlist
about
[1]
WORDLIST preference
[1]
wordlist preference type
[1]
word query
case-sensitivity
[1]
WORLD_LEXER preference type
[1]
X
XML DB
[1]
XML documents
attribute searching
[1]
doctype sensitive sections
[1]
section searching
[1]
XML-enabled Oracle Text Index
[1]
XML full-text index
[1]
XMLIndex
[1]
XML search application
[1]
XML Search Index
[1]
XML searching
[1]
XMLType datatype
[1]
Z
zone section
definition
[1]
nested
[1]
overlapping
[1]
repeating
[1]
Scripting on this page enhances content navigation, but does not change the content in any way.