Results for INDEX


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


Reference, 10g Release 1 (10.1)

10 CTX_QUERY Package

indexSpecify the name of the index. You can specify schema.name. Must be a local index. seed Specify the

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Creating a New Indexindex to the columns you define in a child table when adding a foreign key constraint. Before you add … performance after the new indexes are added. After index creation, Oracle automatically synchronizes the … index with any subsequent inserts, updates or deletes to the base table. Indexes are generally of value … deleting indexes

Programmer's Guide, 10g Release 1 (10.1)

OCI Collection and Iterator Functions

index (IN)Index of the element whose is assigned to.

Reference, 10g Release 1 (10.1)

1 Oracle Text SQL Statements and Operators

DROP INDEXNote: This section describes the DROP INDEX statement as it pertains to dropping a Text domain … index. For a complete description of the DROP INDEX statement, see Oracle Database SQL Reference … . Purpose Use DROP INDEX to drop a specified Text index. Syntax DROP INDEX [schema.]index

Utilities, 10g Release 1 (10.1)

8 SQL*Loader Control File Reference

Index OptionsThis section describes the following SQL*Loader options that control how index entries are created: SORTED INDEXES SINGLEROW

Reference, 10g Release 1 (10.1)

1 Oracle Text SQL Statements and Operators

ALTER INDEXNote: This section describes the ALTER INDEX statement as it pertains to managing a Text domain … index. For a complete description of the ALTER INDEX statement, see Oracle Database SQL Reference … . Purpose Use ALTER INDEX to perform the following maintenance tasks for a CONTEXT, CTXCAT, or CTXRULE … index:

Application Developer's Guide - Expression Filter, 10g Release 1 (10.1)

6 SQL Operators and Statements

CREATE INDEXThe CREATE INDEX statement creates an Expression Filter index for a set of expressions stored in a … assigned to it), and the index should be created in the same schema as the table (storing expressions … ). Format CREATE INDEX [schema_name.]index_name ON [schema_name.].table_name (column_name) INDEXTYPE

User's Guide, 10g Release 1 (10.1)

7 Understanding the Ultra Search Administration Tool

Index Optimization┬áTo ensure fast query results, the Ultra Search crawler maintains an active index of all documents … crawled over all data sources. This lets you schedule when you would like the index to be optimized … . The index should be optimized during hours of low usage. Note: Increasing the crawler cache … directory size can reduce index

Programmer's Guide, 10g Release 1 (10.1)

Cartridge Services -- Parameter Manager Interface

index (IN)Which parameter to retrieve from the parameter list.

Application Developer's Guide - Expression Filter, 10g Release 1 (10.1)

6 SQL Operators and Statements

DROP INDEXThe DROP INDEX statement drops an Expression Filter index. Format DROP INDEX [schema_name … .]index_name; Keyword and Parameters None. Usage Notes Dropping an Expression Filter index automatically drops … all the secondary objects maintained for the index. These objects include a predicate table, one

Programmer's Guide, 10g Release 1 (10.1)

OCI Table Functions

index (IN)Index for starting point of scan.

Developer's Guide, 10g Release 1 (10.1)

21 Extensible Optimizer Interface

INDEX HintThe index hint will apply to domain indexes. In other words, the index hint will force the … optimizer to use the hinted index for a user-defined operator, if possible.

Programmer's Guide, 10g Release 1 (10.1)

OCI Table Functions

index (IN)Index of the element which must be deleted.

Programmer's Guide, 10g Release 1 (10.1)

OCI Table Functions

index (OUT)Index of the last existing element in the table.

Reference, 10g Release 1 (10.1)

1 Oracle Text SQL Statements and Operators

[ schema .] indexSpecify the name of the Text index to create. [ schema.] table ( column ) Specify the name of the … table and column to index. Your table can optionally contain a primary key if you prefer to identify … partitioned table. If you do not specify the LOCAL clause, a global index is created. DATE, NUMBER … attributes can be, provided

Developer's Guide, 10g Release 1 (10.1)

21 Extensible Optimizer Interface

ODCIStatsDelete (Index)Purpose ODCIStatsDelete is called to delete user-defined statistics on an index or a partition of an … index. Table 21-5 ODCIStatsDelete Parameters Parameter Meaning ia Domain index for which statistics … are being deleted statistics OUT Contains aggregate statistics for a partitioned index env Contains … static

Performance Tuning Guide, 10g Release 1 (10.1)

14 The Query Optimizer

Index ScansIn this method, a row is retrieved by traversing the index, using the indexed column values … specified by the statement. An index scan retrieves data from an index based on the value of one or more … columns in the index. To perform an index scan, Oracle searches the index for the indexed

Programmer's Guide, 10g Release 1 (10.1)

OCI Collection and Iterator Functions

index (IN)Index of the element whose pointer is returned.

Programmer's Guide, 10g Release 1 (10.1)

OCI Table Functions

index (IN)Index of the element which is checked for existence.

Reference, 10g Release 1 (10.1)

1 Oracle Text SQL Statements and Operators

CREATE INDEXNote: This section describes the CREATE INDEX statement as it pertains to creating an Oracle Text … domain index. For a complete description of the CREATE INDEX statement, see Oracle Database SQL … Reference. Purpose Use CREATE INDEX to create an Oracle Text index. An Oracle Text index


Was this page helpful?