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
  • 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
  • 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
  • BIG_IO index option [1]
  • BINARY format column value [1]
  • BLOB column
  • blocking operations
    • tuning queries with [1]
  • b-tree index [1]
  • bypassing rows [1]

C

  • cantaloupe dispenser [1]
  • case-insensitive queries [1]
  • case-sensitive
  • catalog application
  • 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
  • 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
  • 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
  • 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
  • CTX_USER_INDEX_ERRORS view [1] , [2]
  • CTX_USER_PENDING view [1]
  • CTXAPP role
  • CTXCAT data storage [1]
  • CTXCAT grammar [1]
  • CTXCAT index
    • about performance [1]
    • automatic synchronization [1]
    • example [1]
    • sub-index [1]
  • CTXFILTERCACHE operator [1]
  • ctxkbtc
  • ctxload
  • 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
  • DATASTORE types
    • summary of [1]
  • DATE column [1]
  • Decision Tree supervised classification [1]
  • decreasing indexing time [1]
  • DEFAULT_INDEX_MEMORY [1]
  • defaults
  • default thesaurus [1]
  • DEFINEMERGE operator [1]
  • DEFINESCORE operator [1]
  • degree of parallelism [1]
  • DESCRIBE_INDEX [1]
  • diacritical marks
    • characters with [1]
  • DIRECT_DATASTORE
  • DML
    • view pending [1]
  • DML processing
    • background [1]
  • DML queue [1]
  • document
  • 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
  • document invalidation [1]
  • document presentation
  • document section
    • searching [1]
  • document sections [1]
  • document services
  • 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
  • EXCHANGE_SHADOW_INDEX procedure [1]
  • execute privileges
  • explain plan [1]

F

  • failed index
  • FAST mode [1]
  • feedback
  • field section
    • definition [1]
    • nested [1]
    • repeated [1]
    • visible and invisible [1]
  • filter
  • 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
  • forward_index attribute [1]
  • forward index [1]
  • fragmentation of index
  • FULL mode [1]
  • full themes
    • obtaining [1]
  • functional lookup [1]
  • fuzzy matching
  • fuzzy operator [1]

G

  • garbage collection [1]
  • German
    • alternate spelling [1]
    • composite words [1]
  • gist
  • grammar
  • grammar CONTEXT [1]
  • granting roles [1]

H

  • HASPATH operator [1]
  • HASPATH operators
  • highlighting
  • 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
  • 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
  • indexed lookup [1]
  • index engine
  • index errors
  • index fragmentation
  • 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
  • indexing plain text [1]
  • indexing time
    • decreasing [1]
  • index memory [1]
  • index synchronization [1]
  • index types
  • init.ora setting [1]
  • INPATH operator
  • INSERT statement
  • 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

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
  • language specific features [1]
  • language-specific knowledge base [1]
  • left-truncated query [1]
  • lexer
  • list of themes
    • definition [1]
    • obtaining [1]
  • loading text
  • 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
  • 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
  • MULTI_LEXER
  • MULTI_LEXER preference type [1]
  • multi-language columns
  • multi-language stoplist
  • 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
  • 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
  • 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
  • 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
  • partitions limit [1]
  • PATH_SECTION_GROUP
  • path section searching [1]
  • PDF support [1] , [2]
  • pending DML
  • pending queue [1]
  • pending updates [1]
  • performance [1]
  • performance tuning
    • indexing [1]
    • querying [1]
    • updating index [1]
  • per-partition swap [1]
  • pet magnet
  • 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
  • query explain plan [1]
  • query expressions [1]
  • query features [1]
  • query feedback [1]
  • query language [1]
  • query log [1] , [2]
  • query optimization
  • Query Parallelized Across Oracle RAC Nodes [1]
  • query performance
  • 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

R

  • Real Application Clusters (RAC) and parallel queries [1]
  • rebuilding an index [1]
  • RECREATE_INDEX_ONLINE
  • 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

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
  • section
  • sectioner
  • section group
    • about [1]
    • and section types [1] , [2]
    • creating with admin tool [1]
  • sectioning
  • section searching
  • 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
  • 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
  • stopword
  • storage
  • 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
  • structured query
  • 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
  • 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
  • theme highlighting [1]
  • themes
  • theme summary
    • definition [1]
  • thesaural queries
  • 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
  • updating your applications [1]
  • URLs
  • 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
  • word continuation [1]
  • wordlist
  • 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