Results for indexing


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


Database SQL Language Reference, 11g Release 2 (11.2)

Using Extensible Indexing

Using Extensible IndexingThis section provides examples of the steps entailed in a simple but realistic extensible indexing … extensible indexing to achieve the same goal. The resulting query will be simpler. The query will require

Database Performance Tuning Guide, 11g Release 2 (11.2)

Configuring a Database for Performance

4.2.3 Indexing DataThe most efficient time to create indexes is after data has been loaded. In this way, space management becomes simpler, and no index maintenance takes place for each row inserted. SQL*Loader automatically uses this technique, but if you are using other methods to do initial data load, then you may need to create indexes manually. Additionally, you can perform index creation in parallel using the PARALLEL

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Presorting Data for Faster IndexingYou can improve the performance of direct path loads by presorting your data on indexed columns. Presorting minimizes temporary storage requirements during the load. Presorting also enables you to take advantage of high-performance sorting routines that are optimized for your operating system or application. If the data is presorted and the existing index is not empty, then presorting minimizes the

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

GeoRaster Operations

3.7 Indexing GeoRaster Data: Function-based indexes on metadata objects using the Oracle XMLType or Oracle Text document indexing

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

Administering Oracle Text

12.6 Servers and IndexingManager in Oracle Enterprise Manager. See Also: Chapter 3, \" Indexing with Oracle Text\" for more information about indexing and index synchronization

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

Indexing with Oracle Text

3.1.7 Indexing and ViewsOracle SQL standards do not support creating indexes on views. If you need to index documents whose contents are in different tables, you can create a data storage preference using the USER_DATASTORE object. With this object, you can define a procedure that synthesizes documents from different tables at index time. See Also: Oracle Text Reference to learn more about USER_DATASTORE Oracle Text does

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

Indexing with Oracle Text

3.2 Considerations For IndexingFormats and Filtering Bypassing Rows for Indexing Document Character Set Document Language Indexing … Special Characters Case-Sensitive Indexing and Querying Language-Specific Features Fuzzy Matching and

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

Spatial Concepts

1.7.1 R-Tree IndexingA spatial R-tree index can index spatial data of up to four dimensions. An R-tree index approximates each geometry by a single rectangle that minimally encloses the geometry (called the minimum bounding rectangle, or MBR), as shown in Figure 1-3.

Text Reference, 11g Release 2 (11.2)

Oracle Text Multilingual Features

D.2 IndexingThe following sections describe the multilingual indexing features: Multilingual Features for Text

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

Indexing with Oracle Text

3.1.6 Parallel IndexingOracle Text supports parallel indexing with CREATE INDEX. When you enter a parallel indexingindexing is an I/O intensive operation, parallel indexing is most effective in decreasing your … indexing time when you have distributed disk access and multiple CPUs. Parallel indexing can

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

Indexing with Oracle Text

3.2.6 Indexing Special Charactersspecify that Oracle Text include or exclude hyphen character (-) when indexing a word such as web … indexing. The way you set the lexer to behave for indexing is the way it behaves for query parsing … you want this character to be included in the token during indexing. For example, if you want your

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

Indexing XMLType Data

6 Indexing XMLType Datacontains these topics: Oracle XML DB Tasks Involving Indexes Overview of Indexing XMLType Data Indexing … overview of indexing Oracle Database Advanced Application Developer's Guide for information about using indexes in application development

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

Indexing XMLType Data

Indexing Repeating (Collection) ElementsIn structured storage, a collection is stored as an ordered collection table (OCT) of an XMLType instance, which means that you can directly access its members. Because the structured storage model directly reflects the fine-grained structure of the XML data, you can create indexes that target individual collection members. You must create such indexes manually. The special feature of automatically

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

Extending Spatial Indexing Capabilities

9 Extending Spatial Indexing Capabilities… In other chapters, the focus is on indexing and querying spatial data that is stored in a single … familiar with, or able to learn about, relevant Oracle database features, such as user-defined data types and function-based indexing.

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

Full-Text Search Over XML Data

Indexing with a CONTEXT Indexavailable when building a full-text index. These choices are expressed as indexing preferences. To … use an indexing preference, add the PARAMETERS clause to CREATE INDEX, as shown in Example 12-29.

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

Linear Referencing System

7.3 Indexing of LRS DataLRS function must be 3301. 7.3 Indexing of LRS Data If LRS data has four dimensions (three plus the

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

Indexing XMLType Data

Overview of Indexing XMLType DataDatabase indexes improve performance by providing faster access to table data. The use of indexes is particularly recommended for online transaction processing (OLTP) environments involving few updates. The principle way you index XML data is using XMLIndex. You can also use Oracle Text CONTEXT indexes to supplement the use of XMLIndex.

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

Spatial Concepts

1.7 Indexing of Spatial DataSection 5.2. 1.7 Indexing of Spatial Data The introduction of spatial indexing capabilities into the … will be documented as they become available. The following sections explain the concepts and options associated with R-tree indexing.

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

Indexing with Oracle Text

3.2.3 Bypassing Rows for IndexingYou can bypass rows in your text table that are not to be indexed, such as rows that contain image data. To do so, create a format column in your table and set it to IGNORE. You name the format column in the parameter clause of CREATE INDEX.

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

Indexing with Oracle Text

3 Indexing with Oracle TextThis chapter provides an introduction to Oracle Text indexing. The following topics are discussed … : About Oracle Text Indexes Considerations For Indexing Creating Oracle Text Indexes Maintaining

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

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)

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

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?