Skip Headers
Oracle® Text Application Developer's Guide
12c Release 1 (12.1)

E17748-07
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
PDF · Mobi · ePub

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, 3.1.2.1, 3.2.14
ABOUT query, 4.2.1
adding for your language, 10.4.1
case-sensitivity, 4.1.8.2
definition, 4.1.6
accents
indexing characters with, 3.2.9.2
ACCUM operator, 4.2.2
ADD_SDATA_SECTION procedure, 8.1.2.6
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, 12.5
all-at-once swap, 3.4.4.1
ALTER INDEX statement
rebuilding index, 3.4.5
resuming failed index, 3.4.3
alternate spelling, 3.2.9.3
alternate_spelling attribute, 3.2.9.3
alternative grammar, 4.1.19
alternative grammar template, 4.1.19
alternative scoring, 4.1.18
alternative scoring template, 4.1.18
AND operator, 4.2.2
application
sample, A, B
applications, updating, 13
attribute
searching XML, 8.3.2
attribute sections, 8.1.2.7
auction table schema example, 3.3.6.3
AUTO keyword
character sets and, 3.2.1.6
AUTO_FILTER filter, 3.1.3.2, 3.2.2, 3.2.4, 7.9.4
AUTO_LEXER with fuzzy matching and stemming, 3.2.11
AUTO_SECTION_GROUP object, 8.1.1.1
AUTOMATIC keyword
character sets and, 3.2.1.6
automatic sections, 8.3.1

B

background DML, 12.6
base_letter attribute, 3.2.9.2
base-letter conversion, 3.2.9.2
BASIC_LEXER preference type, 3.2.5, 3.2.6
BASIC_SECTION_GROUP object, 8.1.1.1, 8.1.3, 8.1.3
BFILE column, 3.2.1.1
indexing, 3.3.5.2
BIG_IO index option, 7.2.6
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
b-tree index, 3.3.6.3.2
bypassing rows, 3.2.3

C

cantaloupe dispenser, A.1
case-insensitive queries, 3.2.7
case-sensitive
ABOUT query, 4.1.8.2
indexing, 3.2.7
queries, 4.1.8
thesaurus, 10.1.2
catalog application, 2.4
example, 2.4
catalog information application, 1.3
flowchart, 1.3.1
catalog table relationships, 1.3
CATSEARCH, 4.1.2
creating index for, 3.3.6.3
operators, 4.3
SQL example, 4.1.2.1
CATSEARCH operator, 1.3, 2.4
CATSEARCH queries, 2.4
CHAR column, 3.2.1.1
Character Large Object (CLOB), 2.3
character set
detection, 3.2.4.1
indexing, 3.2.4
indexing mixed, 3.2.4.2
character set column, 3.2.1.6
charset column, 3.2.4.2
CHARSET_FILTER, 3.1.3.2, 3.2.4
Chinese indexing, 3.2.9.5
CHINESE_VGRAM_LEXER, 3.2.9.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
creating, 2.5.1
example, 2.5
overview illustration, 2.5
CLOB (Character Large Object) datatype, 2.3
CLOB column, 3.2.1.1
indexing, 3.3.5.2
CLOB datatype, 2.3
clustering with classification, 2.5
clustering, see unsupervised classification
column types
supported for indexing, 3.2.1.1
column types that cannot be indexed, 3.2.1.1
combined catalog index, 3.3.6.4
composite attribute, 3.2.9.4
composite words
indexing, 3.2.9.4
concordance, 5.1.3.3
CONNECT role, 2.2
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 operator, 3.1.1
XML search applications and, 1.5.1
CONTAINS query, 2.3
CONTEXT data storage, 3.2.1.2.1
CONTEXT grammar, 4.2
CONTEXT index, 1.2, 3.1.1
about, 3.1.1
creating, 3.3.1, 3.3.5
HTML example, 2.3, 3.3.5.5, A.2.2
structure, 3.1.2
XML search applications and, 1.5.1
continuation, 3.2.6.3
cost for indexing, 3.3.6.2
couch, self-tipping, A.1
counting hits, 4.2.10
CREATE INDEX statement, 3.2
CREATE_INDEX_SCRIPT, 12.4
CREATE_POLICY_SCRIPT, 12.4, 12.4
CREATE_STOPLIST procedure, 3.3.4, 3.3.4.3
CTX_CLS.TRAIN procedure, 6.4
CTX_DDL package, 3.2.14
CTX_DDL.ADD_STOPWORD procedure, 3.3.4.1
CTX_DDL.CREATE_STOPLIST procedure, 3.3.4.1
CTX_DDL.EXCHANGE_SHADOW_INDEX procedure, 3.4.4.1
CTX_DDL.MAXTIME_UNLIMITED procedure, 3.5.2.2
CTX_DDL.POPULATE_PENDING procedure, 3.3.5.4
CTX_DDL.SYNC_INDEX procedure, 2.3, 2.3, 3.3.5.1, 3.5.2
CTX_DOC package, 2.3
CTX_DOC.MARKUP procedure, 2.3
CTX_DOC.POLICY_SNIPPET procedure, 5.1.3.3
CTX_DOC.SNIPPET procedure, 5.1.3.3
CTX_FILTER_CACHE_STATISTICS view, 7.2.5
CTX_INDEX_ERRORS view, 3.4.1, 12.2
CTX_OUTPUT.END_QUERY_LOG, 4.1.20
CTX_OUTPUT.START_QUERY_LOG, 4.1.20
CTX_PENDING view, 12.2
CTX_QUERY.RESULT_SET procedure, 11.2
CTX_REPORT, 3.5.3.5
CTX_REPORT package, 12.4
CTX_REPORT_QUERY_LOG_SUMMARY, 4.1.20
CTX_REPORT_TOKEN_TYPE, 12.4
CTX_REPORT.CREATE_INDEX_SCRIPT, 12.4
CTX_REPORT.CREATE_POLICY_SCRIPT, 12.4, 12.4
CTX_REPORT.DESCRIBE_INDEX, 12.4
CTX_REPORT.DESCRIBE_POLICY, 12.4
CTX_REPORT.INDEX_SIZE, 12.4
CTX_REPORT.INDEX_STATS, 12.4
CTX_REPORT.QUERY_LOG_SUMMARY, 12.4
CTX_REPORT.TOKEN_INFO, 12.4
CTX_THES package
about, 10.1.1.1
CTX_THES.IMPORT_THESAURUS
load thesaurus example, 10.3.2.5
CTX_USER_INDEX_ERRORS view, 3.4.1, 12.2
CTX_USER_PENDING view, 12.2
CTXAPP role, 2.2, 12.1
granting, 2.2
CTXCAT data storage, 3.2.1.2.2
CTXCAT grammar, 4.3
CTXCAT index, 1.3, 3.1.1
about, 3.1.1
about performance, 7.8.17
automatic synchronization, 2.4
creating, 2.4
example, 3.3.6
sub-index, 2.4
CTXFILTERCACHE operator, 7.2.5
ctxkbtc
example, 10.3.2.6
ctxload
load thesaurus example, 10.1.1.3, 10.3.1, 10.3.2.4
CTXRULE index, 1.4, 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, 12.1
CTXSYS.AUTO_FILTER filter type, 2.3
custom CONTEXT index example, 3.3.5.5
custom filtering, 3.2.2.3

D

data staging, 3.1.6
data storage
CONTEXT data, 3.2.1.2.1
CTXCAT data, 3.2.1.2.2
index default, 3.3.5.2
preference example, 3.3.2.1.4
datastore
about, 3.1.3.1, 3.3.1
DATASTORE types
summary of, 3.2.1.8
DATE column, 3.3.5.2
Decision Tree supervised classification, 6.4.1
decreasing indexing time, 3.1.6
default thesaurus, 10.1.4
DEFAULT_INDEX_MEMORY, 7.9.2
defaults
index, 3.3.5.2
DEFINEMERGE operator, 4.2.11
DEFINESCORE operator, 4.2.11
degree of parallelism, 3.2.15
DESCRIBE_INDEX, 12.4
DETAIL_DATASTORE, 3.2.1.2.1
about, 3.2.1.8
diacritical marks
characters with, 3.2.9.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, 12.6
DML queue, 12.2
document
classification, 3.3.7, 6
document classification application, 1.4
overview illustration, 1.4
document collections, 1.2
document filtering, 3.3.5.2
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 section
searching, 3.2.13
document sections, 3.3.3
document services
about, 5.3
document theme, 3.2.9.1, 3.2.14
domain index, 3.1.1
DOMAIN_INDEX_NO_SORT hint
better throughput example, 7.3.2
DOMAIN_INDEX_SORT hint
better response time example, 7.2.2.1
doubly-truncated query, 3.2.12
drop index example, 3.4.2
DROP INDEX statement, 3.4.2
DROP_STOPLIST procedure, 3.3.4.3
dropping an index, 3.4.2

E

endjoin, 3.2.6.3
entity extraction, 3.2.11
EQUIV operator, 4.2.2
errors
DML, 12.2
viewing, 3.4.1
EXCHANGE_SHADOW_INDEX procedure, 3.4.4.1
execute privileges
granting, 2.2
explain plan, 4.1.10

F

failed index
resuming, 3.4.3
FAST mode, 3.5.3.2
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 throughput example, 7.3.2
FIRST_ROWS(n) hint, 7.2.2
flowchart of a simple query application, 1.2.1
format column, 3.2.1.6, 3.2.2.2, 3.2.3
formats
filtering, 3.2.2
supported, 3.2.1.7
forward index, 3.2.8
forward_index attribute, 3.2.8
fragmentation of index, 3.5.3.2, 7.10.2
viewing, 3.5.3.5
FULL mode, 3.5.3.2
full themes
obtaining, 5.2.1.2.2
functional lookup, 7.8.6
fuzzy matching, 3.2.11
default, 3.3.5.2
fuzzy operator, 4.2.5

G

garbage collection, 3.5.3.3
German
alternate spelling, 3.2.9.3
composite words, 3.2.9.4
gist
definition, 5.2
example, 5.2.2.1
GIST procedure, 5.2.2
grammar
alternative, 4.1.19
CTXCAT, 4.3
grammar CONTEXT, 4.2
granting roles, 2.2, 12.1.3

H

HASPATH operator, 8.3.4
HASPATH operators
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, 8.1.3
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 example, 3.3.3.1
HTML_SECTION_GROUP object, 3.3.3.1, 8.1.1.1, 8.1.3, 8.2.1
with NULL_FILTER, 2.3, 3.3.2.2, A.2.2
HTML_SECTION_GROUP type, 2.3

I

IGNORE
format column value, 3.2.3
IGNORE format column type, 3.2.2.2
IGNORE format column value, 3.2.2.2
IGNORE value, 3.1.3.2
incremental indexing, 3.3.5.4
index
about, 3.1
creating, 3.3
dropping, 3.4.2
fragmentation, 3.5.3.2
getting report on, 12.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, 12.4
structure, 3.1.2, 3.5.3.1
synchronizing, 3.5.2, 12.6
viewing information on, 12.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
reducing, 3.5.3.2
index memory, 7.9.2
index synchronization, 2.3
index types
choosing, 3.1.1
INDEX_SIZE, 12.4
INDEX_STATS, 12.4
INDEX_STATS procedure, 3.5.3.5
index_themes attribute, 3.2.9.1
indexed lookup, 7.8.6
indexing
bypassing rows, 3.2.3
considerations, 3.2
languages, 3.2.5
overview of process, 3.1.3
parallel, 3.1.6, 7.9.5
resuming failed, 3.4.3
special characters, 3.2.6
views and, 3.1.7
indexing HTML, 3.2.2.1
indexing performance
FAQs, 7.9
parallel, 7.9.6
indexing plain text, 3.2.2.1
indexing time, 7.9.1
decreasing, 3.1.6
init.ora setting, 3.1.6
INPATH operator, 8.3.4
examples, 8.3.4.2
INSERT statement
example, 2.3
INSO_FILTER (deprecated), 13.5.1
INSO_OUTPUT_FORMATTING attribute (deprecated), 13.5.1
INSO_TIMEOUT attribute (deprecated), 13.5.1
INSOFILTER directive (deprecated), 13.5.1
inverted index, 3.2.8

J

JA16EUC character set, 3.2.4.2
JA16SJIS character set, 3.2.4.2
Japanese indexing, 3.2.9.5
JAPANESE_LEXER, 3.2.9.5
Jdeveloper
Text wizard, A, B

K

knowledge base
about, 10.4
augmenting, 10.3.2
linking new terms, 10.3.2.3
supported character set, 10.4
user-defined, 10.4.1
Korean indexing, 3.2.9.5
KOREAN_MORPH_LEXER, 3.2.9.5

L

language
default setting for indexing, 3.3.5.2
language specific features, 3.2.9
languages
indexing, 3.2.5
language-specific knowledge base, 10.4.1
left-truncated query, 3.2.12
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 column storage, 3.2.16
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
locked base table, 3.1.5
locking parameter for sync_index, 3.5.2.3
logical operators, 4.2.2
low information words, 3.2.14

M

magnet, pet see pet magnet
maintaining the index, 3.4
mapping table
forward index and, 3.2.8
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, 1.4, 2.5, 2.5.1, 3.1.1, 6.3.1
classifying with, 2.5.1
materialized views, indexes on
MAX_INDEX_MEMORY, 7.9.2
maxtime parameter for sync_index, 3.5.2.2
MDATA operators, 8.1.2.4
MDATA section, 8.1.2.4
memory allocation, 3.2.15
index synchronization, 7.10.3
indexing, 7.9.2
querying, 7.8.10
merged word and theme index, 3.1.2.1
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
Microsoft Word support, 3.2.1.7, 3.2.2
migrating from previous releases, 13
mixed character set columns, 3.2.4.2
mixed character sets, 3.2.1.6
mixed formats, 3.2.1.6
filtering, 3.2.2.2
mixed query, 8.1.2.4, 8.1.2.6
mixed query performance, 3.2.17
mixed_case attribute, 3.2.7
mixed-format column, 3.2.2.2
MULTI_COLUMN_DATASTORE, 3.2.1.2.1
about, 3.2.1.8
example, 3.3.2.1.2
MULTI_LEXER
example, 3.3.2.5
MULTI_LEXER preference type, 3.2.5, 3.2.5.2
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

name matching
See name search
name search, 9.1
examples using NDATA sections, 9.2
NCLOB column, 3.3.5.2
NDATA sections
in name search example, 9.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
incremental rebuild and, 3.3.5.3
replace parameter and, 3.3.5.3
nopopulate with RECREATE_INDEX_ONLINE, 3.4.4.1
NOT operator, 4.2.2
NULL maxtime, 3.5.2.2
NULL_FILTER, 3.1.3.2
example, 2.3, 3.3.2.2, A.2.2
NULL_FILTER filter type, 2.3
NULL_FILTER preference type, 3.2.2.1
NULL_SECTION_GROUP object, 8.1.1.1
NUMBER column, 3.3.5.2
number tokenization, 3.2.6.3

O

offset information
highlight, 5.1.3.2
online
recreating a CONTEXT indextype, 3.4.4.1
online index, 3.1.5
ONLINE parameter, 3.1.5
operators
CATSEARCH, 4.3
CONTAINS, 4.2
logical, 4.2.2
MDATA, 8.1.2.4
SDATA, 8.1.2.6
thesaurus, 10.1.1.2
optimizing index, 3.5.3
example, 3.5.3.6
single token, 3.5.3.4
optimizing queries, 4.2.9
FAQs, 7.8
response time, 7.2
throughput, 7.3
with blocking operations, 7.7
OR operator, 4.2.2
Oracle Enterprise Manager, 12.5
Oracle Enterprise Manager and Oracle Text, 12.5
Oracle Text pages in OEM, 12.5
Oracle Text user, 2.2
creating, 2.2
Oracle XML DB, 1.5
Oracle XML Full Text Index, Preface
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
paramstring string, 3.3.4.2
partitioned index, 7.8.14
improved response time, 7.2.3
partitioned table
querying, 3.1.4.1
partitions limit, 3.1.4
path section searching, 8.3.4
PATH_SECTION_GROUP
example, 8.3.4.1
PDF support, 3.2.1.7, 3.2.2
pending DML
viewing, 3.5.1
pending queue, 3.3.5.4
pending updates, 12.2
performance, 3.2.15
performance tuning
indexing, 7.9
querying, 7.8
updating index, 7.10
per-partition swap, 3.4.4.1
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
PLAINTEXT value, 3.2.8
PL/SQL functions
calling in contains, 4.2.8
POPULATE keyword, 3.3.5.3
POPULATE_PENDING procedure, 3.3.5.4
preferences
creating (examples), 3.3.2
creating with admin tool, 12.5
dropping, 3.4.6
prefix indexing example, 3.3.2.6
previous releases, migrating from, 13
printjoin character, 3.2.6.1
printjoin characters example, 3.3.2.4
PROCEDURE_FILTER, 3.2.2.3
PROCEDURE_FILTER example, 3.3.2.3
PSP application, A.2, B.2
punctuation identification, 3.2.6.3

Q

query
ABOUT, 4.2.1
analysis, 4.1.20
blocking operations, 7.7
case-sensitive, 3.2.7, 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, 12.4
log, 4.1.20
MATCHES, 4.1.3
mixed, 8.1.2.4, 8.1.2.6
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.6
viewing information on, 12.4
viewing log of, 12.4
query analysis, 4.1.20
query application, 1.2
example, 2.3
flowchart, 1.2.1
sample, 1.2.1
query explain plan, 4.1.10
query expressions, 4.1.7
query features, 4.1.21
query feedback, 4.1.9
query language, 4.1.16
query log, 4.1.20, 12.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 processing with FILTER BY and ORDER BY example, 3.3.5.6
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_filter_cache_size basic storage attribute, 7.2.5
QUERY_LOG_SUMMARY, 12.4
queue
DML, 12.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
RECREATE_INDEX_ONLINE procedure
no populate with, 3.4.4.1
swap and noswap with, 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
remote LOB column, 3.2.16
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
RESOURCE role, 2.2
response time
improving, 7.2
optimizing for, 4.2.9
result buffer size
increasing, 7.7
result set interface, 11
result sets, 11
resuming failed index, 3.4.3
rewriting queries, 4.1.14
right-truncated query, 3.2.12
roles
granting, 2.2, 12.1.3
system-defined, 12.1
rowid, 3.5.1
rule table
creating, 2.5.1
rule-based classification, 2.5, 3.1.1, 6.3
rules
about for simple classification, 2.5

S

sample application, A, B
save_copy attribute, 3.2.8
scheduled swap, 3.4.4.1
scheduling local index re-creation with all-at-once swap, 3.4.4.1
scoring
alternative, 4.1.18
SDATA operators, 8.1.2.6
SDATA section, 8.1.2.6
searching
XML, 1.5
section
attribute, 8.1.2.7
field, 8.1.2.2
groups and types, 8.1.2, 8.1.3
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.6
special, 8.1.2.8
stop section, 8.1.2.3
types and groups, 8.1.2, 8.1.3
zone, 8.1.2.1
section group
about, 3.3.1
and section types, 8.1.2, 8.1.3
creating with admin tool, 12.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
See also rule-based classification, 2.5
See also simple classification, 2.5
SELECT statement, 1.2
with CONTAINS, 2.3
self-tipping couch, A.1
SEPARATE_OFFSETS index option, 7.2.7, 7.2.8
SGA memory allocation, 7.9.2
simple classification, 2.5, 3.1.1
rules and, 2.5
simple classification, see rule-based classification
single themes
obtaining, 5.2.1.2.1
size of index, viewing, 12.4
skipjoin character, 3.2.6.2
SORT_AREA_SIZE, 7.7, 7.8.10, 7.9.2
special characters, 3.2.6
indexing, 3.2.6
special sections, 8.1.2.8
spelling
alternate, 3.2.9.3
searching different
SQE operator, 4.2.7
SQL CONTAINS operator, 1.2
SQL*Loader, 2.3, 2.4
startjoin, 3.2.6.3
stem operator, 3.2.11, 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, 12.5
default, 3.3.5.2
multi-language, 3.2.14.2, 3.3.4.1
PL/SQL procedures for, 3.3.4.3
stoptheme, 3.3.4.2, 3.3.4.2
about, 3.2.14
definition, 4.1.6.1
stopword, 3.3.4, 3.3.4.2
about, 3.2.14, 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
file path names, 3.2.1.3
structured document information, 3.2.1.5
storing text, 3.2.1
about, 3.2.1.2
different methods illustration, 3.2.1
structure
CONTEXT index, 3.1.2
structure of index, 3.5.3.1
structured data
adding, 8.1.2.6
removing, 8.1.2.6
section, 8.1.2.6
structured query
example, 3.3.6
structured query clause, 3.3.6.3.1
sub-index, 2.4
substring indexing example, 3.3.2.6
supervised classification, 2.5, 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, 10.2.1
sync_index locking parameter, 3.5.2.3
sync_index maxtime parameter, 3.5.2.2
SYNC_INDEX procedure, 2.2, 2.3
synchronization, 3.4.4.1
synchronize index, 2.3
synchronizing index, 3.5.2, 12.6
improving performance, 7.10
synonyms
defining, 10.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 fragments, 3.2.1
text highlighting, 5.1.1
text storage, 3.2.1
Text-on-XML Method, 1.5.2.2
that stopword, 3.2.14
theme functionality
adding, 10.4.1
theme highlighting, 5.1.2
theme summary
definition, 5.2
themes
indexing, 3.2.9.1
THEMES procedure, 5.2.1
thesaural queries
about, 4.1.11
thesaurus
about, 10.1
adding to knowledge base, 10.3.2
case-sensitive, 10.1.2
default, 10.1.4, 10.1.4
defining terms, 10.2
hierarchical relations, 10.2.2
loading custom, 10.3.1
operators, 10.1.1.2
supplied, 10.1.5
using in application, 10.3
thesaurus operator, 4.2.5
this stopword, 3.2.14
throughput
improving query, 7.3
tildes
indexing characters with, 3.2.9.2
time limit
setting for synchronizing, 3.4.4.1
token prefix, 3.2.12
token separation, 3.2.6.3
TOKEN_INFO, 12.4
TOKEN_TYPE, 12.4
tokenization behavior, 3.2.6.3
tokenizing, 3.2.5
tokens, 3.1.3
tracing, 7.5
TRAIN procedure, 6.4
transactional, 3.3.5.1, 3.3.6.1, 3.5
Transparent Data Encryption
enabled column and,enabled tablespace and, 3.1.1
tuning queries
for response time, 7.2
for throughput, 7.3
increasing result buffer size, 7.7

U

umlauts
indexing characters with, 3.2.9.2
unsupervised classification, 6.5
UPDATE_SDATA procedure, 8.1.2.6
updating index performance
FAQs, 7.10
updating your applications, 13
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, 12.1
USER_DATASTORE, 3.1.7
about, 3.2.1.8
USER_FILTER, 3.2.2.3
USER_LEXER preference type, 3.2.5
user-defined lexer interface, 3.2.5.1

V

VARCHAR2 column, 3.2.1.1
viewing information on indexes and queries, 12.4
viewing size of index, 12.4
views
indexing and, 3.1.7
materialized

W

WHERE clause, 1.2
whitespace, 3.2.6.3
whitespace-delimited language, 3.2.5
wildcard operator, 4.2.5
improving performance, 7.8.13
wildcard queries, 3.2.12
WITHIN operator, 3.3.3
wizard
Oracle Text addin, A, B
word continuation, 3.2.6.3
word query, 4.1.4
case-sensitivity, 4.1.8.1
wordlist
about, 3.3.1
WORDLIST preference, 3.1.3.5
wordlist preference type, 3.2.12
WORLD_LEXER preference type, 3.2.5

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 full text index, Preface
XML search application, 1.5
XML searching, 1.5
XML_SECTION_GROUP object, 8.1.1.1, 8.1.3
XMLIndex, Preface
XMLType datatype, 3.2.1.2.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