docs.oracle.com/cd/B19306_01/server.102/b14231/indexes.htm See Also: Oracle Database Concepts for conceptual information about indexes and indexing, including descriptions of the various indexing schemes offered by Oracle
docs.oracle.com/cd/B28359_01/server.111/b28310/indexes... Creating Indexes. This section describes how to create indexes. To create an index in your own schema, at least one of the following conditions must be true:
www.techonthenet.com/oracle/indexes.php This Oracle tutorial explains how to create, rename and drop indexes in Oracle with syntax and examples. An index is a performance-tuning method of allowing faster retrieval of records.
oracle-base.com/articles/8i/function-based-indexes.php Oracle Function Based Indexes. Traditionally, performing a function on an indexed column in the where clause of a query guaranteed an index would not be used.
www.dba-oracle.com/concepts/indexes_for_table_query.htm See the indexes for a table. It is not unusual to wonder what indexes a specific table might have, and what columns in the table are assigned to those indexes.
www.oracle.com/technetwork/articles/sharma-indexes... Bitmap Index vs. B-tree Index: Which and When? by Vivek Sharma Understanding the proper application of each index can have a big impact on performance.
oracle-base.com/articles/11g/invisible-indexes-11gr1.php Invisible Indexes in Oracle Database 11g Release 1. Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level.
asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11... In Sybase, "There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way records in the table are physically stored.
https://community.oracle.com/thread/621318?start=0&tstar... You can not disable the Index.You can - if it is a function based index: SQL> create index emp_idx on emp (upper(ename)) / Index created. SQL> alter index emp_idx disable / Index altered.
https://blogs.oracle.com/sysdba/entry/when_to_rebuild_index Index is one of intersting objects in database, which always attract DBAs and Developers to fine tune their queries. Because index is just like salt in food.
asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11... Hi Tom, Would rebuilding indexes not help in case you want to re-balance the b*tree? Particularly in case of indexes deriving their values from a monotonically increasing sequence (as I trust most of the unique/foreign keys are)?
sql-plsql.blogspot.com/2010/06/non-clustered-indexes.html Clustered indexes & Non-Clustered indexes - All You Need to Know Clustered indexes sort and store the data rows in the table based on their key values.
www.asktheoracle.net/how-do-indexes-work-internally-in... There are several types of index available for use in Oracle databases, the most common ones (in our experience) are B-tree (balanced tree) indexes, function-based indexes and bitmap indexes.
www.careerride.com/Oracle-how-to-list-all-indexes.aspx <<Previous Next>> Oracle - Explain how to list all indexes in your schema - April 10, 2009 at 11:00 AM Explain how to list all indexes in your schema.
www.databasedesign-resource.com/oracle-indexes.html Oracle indexes : Adding database performance Oracle indexes : Proper database indexing is a crucial factor for your database performance. Most Oracle databases have hundreds or even thousands of indexes.
www.allinterview.com/showanswers/10467/how-many... nimisha : Answer # 4: There are four reguler types of Indexes in oracle 1.Normal index 2.Bitmap indexs 3.Function based indexs 4.Domain indexes. The custom and recommended types are of 2 types
www.toadworld.com/platforms/oracle/w/wiki/4221.create... This topic contains the following examples: parallel; COMPRESS; NOLOGGING; Cluster Index; NULL; Function-Based Index; Function-based Index on Type Method; COMPUTE STATISTICS
www.sqlines.com/oracle/function_based_indexes In Oracle, you can create a function-based index that stores precomputed results of a function or expression applied to the table columns. Function-based indexes are used to increase the performance of queries that use functions in the WHERE clause.
dbaforums.org/oracle/index.php?showtopic=957 I'm in 10g, but don't have access to the graphical EM. I need to use SQL*Plus to find out what columns an index is indexing on. I know how to show the indexes for a table by using:
www.databasejournal.com/features/oracle/article.php/3413961 Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for a very specific purpose.