Results for function based


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


Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Understanding Indexes and Clusters

Using Function-based IndexesA function-based index includes columns that are either transformed by a function, such as the … UPPER function, or included in an expression, such as col1 + col2. Defining a function-based index on … function or expression is used in a WHERE clause or an ORDER BY clause.

Concepts, 9i Release 2 (9.2.0.2)

Schema Objects

Function-Based Indexesbeing indexed. A function-based index computes the value of the function or expression and stores it … in the index. You can create a function-based index as either a B-tree or a bitmap index. The … function-based index on a LOB column, REF, or nested table column, nor

Concepts, 9i Release 2 (9.2.0.2)

Dependencies Among Schema Objects

Function-Based Index DependenciesFunction-based indexes depend on functions used in the expression that defines the index. If a PL … discusses requirements for function-based indexes and what happens when a function is changed in any … function-based index: The following initialization parameters must

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Introduction to LOBs

Function-Based Indexing on LOBsA function-based index is an index built on an expression. It extends your indexing capabilities … beyond indexing on a column. A function-based index increases the variety of ways in which you can … access data. Function-based indexes cannot currently be built on nested tables. However,

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting an Index Strategy

Advantages of Function-Based IndexesFunction-based indexes: Increase the number of situations where the optimizer can perform a range … more accurately if the expressions are materialized in a function-based index. (Expressions of function … order sorts with the DESC keyword, and linguistic-based sorts with the NLSSORT

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting an Index Strategy

Examples of Function-Based IndexesExample: Function-Based Index for Case-Insensitive Searches The following command allows faster … command uses the function-based index on UPPER ( e_name ) to return all of the employees with name like … Expressions with a Function-Based Index The following command computes a value for

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting an Index Strategy

Restrictions for Function-Based IndexesNote the following restrictions for function-based indexes: Only cost-based optimization can use … function-based indexes. Remember to set the QUERY_REWRITE_ENABLED initialization parameter to TRUE … DETERMINISTIC or not. Expressions used in a function-based index cannot

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Indexes

Creating a Function-Based IndexFunction-based indexes facilitate queries that qualify a value returned by a function or expression … function-based indexes. Features of Function-Based Indexes Function-based indexes allow you to … , descending order sorts with the

Migration, 9i Release 2 (9.2.0.2)

After Upgrading a Database

Rebuild Unusable Function-Based IndexesDuring an upgrade, some function-based indexes may become unusable. To find these indexes, issue … funcidx_status = 'DISABLED'; Rebuild the unusable function-based indexes listed.

Spatial User's Guide and Reference, 9i Release 2 (9.2.0.2)

Extending Spatial Indexing Capabilities

7.2 SDO_GEOMETRY Objects in Function-Based IndexesA function-based spatial index facilitates queries that use locational information (of type … SDO_GEOMETRY) returned by a function or expression. In this case, the spatial index is created based on the … function-based indexes, see the following for detailed explanations of the their

Spatial User's Guide and Reference, 9i Release 2 (9.2.0.2)

Locator

Function-based spatial indexing Section 7.2Ability to integrate with third-party geocoders Section 1.10 Function-based spatial indexing Section 7.2

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting an Index Strategy

When to Use Function-Based IndexesA function-based index is an index built on an expression. It extends your indexing capabilities … beyond indexing on a column. A function-based index increases the variety of ways in which you can … value for s. The expression indexed by a function-based index can be an arithmetic expression

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Understanding Indexes and Clusters

Setting Parameters to Use Function-Based Indexes in QueriesTo use function-based indexes in queries, you need to set the QUERY_REWRITE_ENABLED and … QUERY_REWRITE_INTEGRITY parameters. QUERY_REWRITE_ENABLED To enable function-based indexes for queries, set the … QUERY_REWRITE_ENABLED is set to FALSE, then function-based indexes are not used

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Linguistic Sorting

Improving Case-Insensitive Searches with a Function-Based IndexYou can create a function-based index that improves the performance of case-insensitive searches

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Design Considerations for Oracle Objects

Function-Based Indexes on the Return Values of Type MethodsA function-based index is an index based on the return values of an expression or function. The … function may be a method function of an object type. A function-based index built on a method function … the function

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Managing Oracle XML DB Using Oracle Enterprise Manager

Creating a Function-Based Index Based on XPath ExpressionsSee FigureĀ 21-26 shows the Create Index General page. To create a function-based index based on an … inside your function-based index statement. For tables with XMLType columns, first click the lower left … not need to change this. Figure 21-26 Enterprise Manager: Creating a Function-Based

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Using XMLType

Creating Function-Based Indexes on XMLType ColumnsYou can speed up by queries by building function-based indexes on existsNode() or those portions of … the XML document that use extract(). Example 4-40 Creating a Function-Based Index on an extract … e.poDoc.extract('//PONO/text()').getNumberVal()= 100; you can create a function-based

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE CLUSTER to CREATE JAVA, 9 of 12

CREATE FUNCTIONfunction-based indexes depend on the function, Oracle marks the indexes DISABLED. See Also: ALTER … intend to call the function in the expression of a function-based index or from the query of a … Warehousing Guide for information on materialized views CREATE INDEX for information on

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30557 function based index could not be properly maintainedCause: The user updated a column on which a function based index is present which was not

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30554 function-based index string. string is disabledCause: An attempt was made to access a function-based index that has been marked disabled because … the function on which the index depends has been changed. Action: Perform one of the following





Was this page helpful?

Integrated Cloud Applications & Platform Services