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
  • collocates 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_CLOB_QUERY procedure 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 columns
    • updating 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
  • 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
  • NEAR2 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
    • Upgrading 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
  • sentiment analysis
    • about 1
    • creating classifiers 1
    • interfaces 1
    • sentiment classifiers 1
    • training sentiment models 1
    • using CTX_DOC package 1
    • using XML Query RSI 1
  • sentiment classifiers
    • about 1
    • creating 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 search application 1
  • XML searching 1
  • XMLType datatype 1

Z

  • zone section
    • definition 1
    • nested 1
    • overlapping 1
    • repeating 1