Results for indexing


21 to 40 of 740 results. Prev  Next
Results per page:   20  | 40 | 60


Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

2 Oracle Text Indexing ElementsOracle Text provides indexing elements for creating Oracle Text indexes and for specifying indexing … preferences. This chapter describes the indexing elements that you can use to create an Oracle Text index.

Spatial Developer's Guide, 11g Release 2 (11.2)

SQL Statements for Indexing Spatial Data

18 SQL Statements for Indexing Spatial DataThis chapter describes the SQL statements used when working with the spatial object data type. The statements are listed in Table 18-1. Table 18-1 Spatial Index Creation and Usage Statements

Text Application Developer's Guide, 11g Release 2 (11.2)

Indexing with Oracle Text

3.2.7 Case-Sensitive Indexing and Querying-sensitive indexing, use the mixed_case attribute of the BASIC_LEXER preference. See Also: Oracle Text Reference to learn more about the BASIC_LEXER

Spatial Developer's Guide, 11g Release 2 (11.2)

Indexing and Querying Spatial Data

5 Indexing and Querying Spatial DataAfter you have loaded spatial data (discussed in Chapter 4 ), you should create a spatial index on it to enable efficient query performance using the data. This chapter describes how to: Create a spatial index (see Section 5.1 ) Query spatial data efficiently, based on an understanding of the Oracle Spatial query model and primary and secondary filtering (see Section 5.2 )

Text Application Developer's Guide, 11g Release 2 (11.2)

Tuning Oracle Text

7.8 Frequently Asked Questions About Indexing PerformanceThis section answers some of the frequently asked questions about indexing performance.

XML DB Developer's Guide, 11g Release 2 (11.2)

Indexing XMLType Data

Indexing XMLType Data Stored Object-Relationallyfunctional expression. \"Indexing Non-Repeating text() Nodes or Attribute Values\" describes this. If the … indexes manually. \"Indexing Repeating (Collection) Elements\" describes this.

Text Application Developer's Guide, 11g Release 2 (11.2)

Tuning Oracle Text

7.8.1 How long should indexing take?Answer: Indexing text is a resource-intensive process. The speed of indexing will depend on the … power of the hardware involved. Indexing speed depends on CPU and I/O capacity. Given sufficient I/O … , location of your data, and the calls to user-defined datastores, filters, and lexers can have an impact on your indexing

Text Application Developer's Guide, 11g Release 2 (11.2)

Tuning Oracle Text

7.8.5 Can parallel indexing improve performance?Answer: Parallel indexing can improve index performance when you have a large amount of data, and … the index with up to three separate indexing processes depending on your resources. Parallel … indexing can also be used to create local partitioned indexes on partitioned tables. However, indexing … systems. Because

Text Application Developer's Guide, 11g Release 2 (11.2)

Indexing with Oracle Text

3.1.3 The Oracle Text Indexing ProcessThis section describes the Oracle Text indexing process. Initiate the indexing process with the … CREATE INDEX statement. Initiate the indexing process using the CREATE INDEX statement to create an … 3-1 shows the indexing process. This process is a data stream that is acted upon by the different … indexing

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

2.1.1 Creating Preferences, you can also set attributes with the CTX_DDL. SET_ATTRIBUTE procedure. An indexing type names a … class of indexing objects that you can use to create an index preference. A type, therefore, is an … nature of either indexing types or system preferences. You specify indexing preferences with the CREATE … INDEX

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

2.2.2 MULTI_COLUMN_DATASTOREindexing, the system concatenates the text columns, tags the column text, and indexes the text as a … list of columns to be concatenated during indexing. You can also specify any allowed expression for … before indexing using the default format mask. The TO_CHAR function can be used in the column list … ). NEWLINE: Column text

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

http_proxySpecify the fully qualified name of the host machine that serves as the HTTP proxy (gateway) for the machine on which Oracle Text is installed. You can optionally specify port number with a colon in the form hostname:port. You must set this attribute if the machine is in an intranet that requires authentication through a proxy server to access Web files located outside the firewall.

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

2.3.3 NULL_FILTERperformed. NULL_FILTER has no attributes. 2.3.3.1 Indexing HTML Documents If your document set is … section groups and indexing HTML documents, see \"Section Group Types\".

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

numgroupS pecify a single character that, when it appears in a string of digits, indicates that the digits are groupings within a larger single unit. For example, comma ',' might be defined as a numgroup character because it often indicates a grouping of thousands when it appears in a string of digits.

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

startjoins/endjoinsFor startjoins, specify the characters that when encountered as the first character in a token explicitly identify the start of the token. The character, as well as any other startjoins characters that immediately follow it, is included in the Text index entry for the token. In addition, the first startjoins character in a string of startjoins characters implicitly ends the previous token. For endjoins,

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

index_themesSpecify YES to index theme information in English or French. This makes ABOUT queries more precise. The index_themes and index_text attributes cannot both be NO. The default is YES. You can set this parameter to TRUE for any index type, including CTXCAT. To enter an ABOUT query with CATSEARCH, use the query template with CONTEXT grammar. Note: index_themes requires an installed knowledge base. A knowledge

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

prove_themesSpecify YES to prove themes. Theme proving attempts to find related themes in a document. When no related themes are found, parent themes are eliminated from the document. While theme proving is acceptable for large documents, short text descriptions with a few words rarely prove parent themes, resulting in poor recall performance with ABOUT queries. Theme proving results in higher precision and less

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

alternate_spellingSpecify either GERMAN, DANISH, or SWEDISH to enable the alternate spelling in one of these languages. Enabling alternate spelling enables you to query a word in any of its alternate forms. Alternate spelling is off by default; however, in the language-specific scripts that Oracle provides in admin/defaults ( drdefd.sql for German, drdefdk.sql for Danish, and drdefs.sql for Swedish), alternate spelling

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

2.4.3 CHINESE_VGRAM_LEXERThe CHINESE_VGRAM_LEXER type identifies tokens in Chinese text for creating Text indexes. 2.4.3.1 CHINESE_VGRAM_LEXER Attribute The CHINESE_VGRAM_LEXER has the following attribute: Table 2-18 CHINESE_VGRAM_LEXER Attributes Attribute Attribute Value mixed_case_ASCII7 Enable mixed-case (upper- and lower-case) searches of ASCII7 text (for example, cat and Cat ). Allowable values are YES and NO (default).

Text Reference, 11g Release 2 (11.2)

Oracle Text Indexing Elements

2.4.5 JAPANESE_VGRAM_LEXERThe JAPANESE_VGRAM_LEXER type identifies tokens in Japanese for creating Text indexes. This lexer supports the stem ($) operator. 2.4.5.1 JAPANESE_VGRAM_LEXER Attributes This lexer has the following attributes: Table 2-20 JAPANESE_VGRAM_LEXER Attributes Attribute Attribute Value delimiter Specify whether to consider certain Japanese blank characters, such as a full-width forward slash or a full-width


Was this page helpful?