How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
ALTER INDEX → Purpose 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
CREATE INDEX → Purpose 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:
DROP INDEX → Purpose 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
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
Maintaining Index-Organized Tables → Index-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
Creating an Index Explicitly → INDEX. 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
Managing Index-Organized Tables → This 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
Creating an Invisible Index → An invisible index is an index that is ignored by the optimizer unless you explicitly set the
Renaming an Index → Re naming an Index To rename an index, issue this statement: ALTER INDEX index_name RENAME TO new_name;
Monitoring Index Usage → an 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
Creating an Index Online → you 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
Creating Index-Organized Tables → You 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
Analyzing Index-Organized Tables → Just 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
Rebuilding an Existing Index → Before 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
Making an Index Invisible → An 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
Creating a Large Index → When 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
Creating an Unusable Index → When 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
Consider Parallelizing Index Creation → You 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
Making an Index Unusable → When 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
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