You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for index


1 to 20 of 6520 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

ALTER INDEX

ALTER INDEXPurpose Use the ALTER INDEX statement to change or rebuild an existing index. See Also: CREATE … INDEX for information on creating an index Prerequisites The index must be in your own schema or you … must have the ALTER ANY INDEX system privilege. To rebuild an online index

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

CREATE INDEX

CREATE INDEXPurpose Use the CREATE INDEX statement to create an index on: One or more columns of a table, a … partitioned table, an index-organized table, or a cluster One or more scalar typed object attributes of … a table or a cluster A nested table storage table for indexing a nested table column An index is a … index:

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

DROP INDEX

DROP INDEXPurpose Use the DROP INDEX statement to remove an index or domain index from the database. When you … drop a global partitioned index, a range-partitioned index, or a hash-partitioned index, all the … index partitions are also dropped. If you drop a composite-partitioned

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

Comments

INDEX Hint\", tablespec::=, indexspec::= ) The INDEX hint instructs the optimizer to use an index scan for the … specified table. You can use the INDEX hint for function-based, domain, B-tree, bitmap, and bitmap join … indexes. The behavior of the hint depends on the indexspec specification: If the INDEX hint … specifies

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Maintaining Index-Organized TablesIndex-organized tables differ from ordinary tables only in physical organization. Logically, they … are manipulated in the same manner as ordinary tables. You can specify an index-organized table just … Index-Organized Tables All of the alter options available for ordinary tables are available for index … key

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Creating an Index ExplicitlyINDEX. The following statement creates an index named emp_ename for the ename column of the emp … table: CREATE INDEX emp_ename ON emp(ename) TABLESPACE users STORAGE (INITIAL 20K NEXT 20k); Notice … that several storage settings and a tablespace are explicitly specified for the index. If you do not … specify

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Managing Index-Organized TablesThis section describes aspects of managing index-organized tables, and contains the following … topics: What Are Index-Organized Tables? Creating Index-Organized Tables Maintaining Index-Organized … Tables Creating Secondary Indexes on Index-Organized Tables Analyzing Index-Organized

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Creating an Invisible IndexAn invisible index is an index that is ignored by the optimizer unless you explicitly set the

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Renaming an IndexRe naming an Index To rename an index, issue this statement: ALTER INDEX index_name RENAME TO new_name;

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Monitoring Index Usagean index is not being used, then it can be dropped, eliminating unnecessary statement overhead. To … start monitoring the usage of an index, issue this statement: ALTER INDEX index MONITORING USAGE … ; Later, issue the following statement to stop the monitoring: ALTER INDEX index NOMONITORING

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Creating an Index Onlineyou are building or rebuilding indexes on that table. You can perform DML operations while the index … creating or rebuilding an index online. The following statements illustrate online index build … operations: CREATE INDEX emp_name ON emp (mgr, emp1, emp2, emp3) ONLINE; Note: Keep in mind that the time … that

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Creating Index-Organized TablesYou use the CREATE TABLE statement to create index-organized tables, but you must provide … additional information: An ORGANIZATION INDEX qualifier, which indicates that this is an index-organized … following: An OVERFLOW clause, which preserves dense clustering of the B-tree index by enabling the … stored in

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Analyzing Index-Organized TablesJust like ordinary tables, index-organized tables are analyzed using the DBMS_STATS package, or the … ANALYZE statement. Collecting Optimizer Statistics for Index-Organized Tables To collect optimizer … the index-organized countries table in the hr schema: EXECUTE DBMS_STATS.GATHER_TABLE_STATS ('HR … ','COUNTRIES'); The DBMS_STATS

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Rebuilding an Existing IndexBefore rebuilding an existing index, compare the costs and benefits associated with rebuilding to … those associated with coalescing indexes as described in Table 21-1. When you rebuild an index, you … use an existing index as the data source. Creating an index in this manner enables you to change … storage characteristics

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Making an Index InvisibleAn invisible index is ignored by the optimizer unless you explicitly set the … OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter to TRUE at the session or system level. Making an index invisible … is an alternative to making it unusable or dropping it. You cannot make an individual index

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Creating a Large IndexWhen creating an extremely large index, consider allocating a larger temporary tablespace for the … index creation using the following procedure: Create a new temporary tablespace using the CREATE … USER statement to make this your new temporary tablespace. Create the index using the CREATE INDEX

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Creating an Unusable IndexWhen you create an index in the UNUSABLE state, it is ignored by the optimizer and is not … maintained by DML. An unusable index must be rebuilt, or dropped and re-created, before it can be used. If … the index is partitioned, then all index partitions are marked UNUSABLE. Beginning with Oracle … Database 11 g

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Consider Parallelizing Index CreationYou can parallelize index creation, much the same as you can parallelize table creation. Because … multiple processes work together to create the index, the database can create the index more quickly … than if a single server process created the index sequentially. When creating an index in parallel

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Making an Index UnusableWhen you make an index unusable, it is ignored by the optimizer and is not maintained by DML. When … you make one partition of a partitioned index unusable, the other partitions of the index remain … valid. You must rebuild or drop and re-create an unusable index or index partition before using it. The

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

What Are Index-Organized Tables?What Are Index-Organized Tables ? An index-organized table has a storage organization that is a … unordered collection (heap), data for an index-organized table is stored in a B-tree index structure in a … primary key sorted manner. Each leaf block in the index structure stores both the key and nonkey