Results for indexing


1 to 20 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


Was this page helpful?