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
Bitmap Indexes → Bitmap indexes on index-organized tables are supported, provided the index-organized table is
Bitmap Indexes → indexes are very space efficient. Bitmap indexing efficiently merges indexes that correspond to several … Bitmap Indexes and Nulls Bitmap Indexes on Partitioned Tables Benefits for Data Warehousing … data in the table. Bitmap indexes
12.7 Viewing Bitmap Indexes with EXPLAIN PLAN → Index row sources using bitmap indexes appear in the EXPLAIN PLAN output with the word BITMAP … EXPLAIN PLAN with Bitmap Indexes EXPLAIN PLAN FOR SELECT * FROM t WHERE c1 = 2 AND c2 <> 6 OR c3 BETWEEN … 10 AND 20; SELECT STATEMENT TABLE ACCESS T BY INDEX ROWID BITMAP CONVERSION TO ROWID
14.5 Using Bitmap Indexes for Performance → Bitmap indexes can substantially improve performance of queries that have all of the following … . The bitmap indexes used in the queries have been created on some or all of these low- or medium … -cardinality columns. The tables in the queries contain many rows. You can use multiple bitmap indexes
Bitmap Indexes and Nulls → Unlike most other types of indexes, bitmap indexes include rows that have NULL values. Indexing of … COUNT. Example 6-2 Bitmap Index SELECT COUNT(*) FROM customers WHERE cust_marital_status IS NULL; This … query uses a bitmap index on cust_marital_status. Note that this query would not be able to use
Bitmap Indexes on Partitioned Tables → You can create bitmap indexes on partitioned tables but they must be local to the partitioned table … —they cannot be global indexes. A partitioned table can only have global B-tree indexes, partitioned
Overview of Bitmap Indexes in Data Warehousing → Bitmap indexes are widely used in data warehousing environments. The environments typically have … the table. Bitmap indexes are typically only a fraction of the size of the indexed data in the table … , bitmap indexes save space. Bitmap indexes are
Using Bitmap Indexes in Data Warehouses → Bitmap indexes are widely used in data warehousing environments. The environments typically have … data in the table. Bitmap indexes are typically only a fraction of the size of the indexed data in … bitmap index provides the same functionality as a regular index. Bitmap indexes
Bitmap Indexes on Index-Organized Tables → Oracle Database supports bitmap indexes on partitioned and nonpartitioned index-organized tables. A … mapping table is required for creating bitmap indexes on an index-organized table. Mapping Table … one mapping table for each index-organized table and it is used by all the bitmap indexes
About Indexes → Oracle Real Application Clusters applications Bitmap indexes: compact; work best for columns with a … Indexes are optional structures associated with tables and clusters that allow SQL queries to … . You can use indexes without rewriting any queries. Your results are the same, but you see them more … functionality.
Guidelines for Managing Indexes → Data Warehousing Guide for information about bitmap indexes Oracle Database Data Cartridge Developer's … This section discusses guidelines for managing indexes and contains the following topics: Create … Indexes After Inserting Table Data Index the Correct Tables and Columns Order Index Columns for … Performance
6 Indexes → This chapter contains the following topics: Using Bitmap Indexes in Data Warehouses Using B-Tree … Indexes in Data Warehouses Using Index Compression Choosing Between Local Indexes and Global Indexes
Benefits for Data Warehousing Applications → Bitmap indexes are primarily intended for data warehousing applications where users query the data … transactions modifying the data. Parallel query and parallel DML work with bitmap indexes. Bitmap … , \"Schema Modeling Techniques\" for further information about using bitmap indexes
Using B-Tree Indexes in Data Warehouses → common in environments using third normal form schemas. In general, bitmap indexes should be more … associated with each index entry. In general, use B-tree indexes when you know that your typical … . Instead, you might want to read or scan the table. B-tree indexes are most commonly used in a data … because typical
Using Index Compression → Bitmap indexes are always stored in a patented, compressed manner without the need of any user … intervention. B-tree indexes, however, can be stored specifically in a compressed manner to enable huge
gender='M' gender='F' → ' AND cust_income_level IN ('H: 150,000 - 169,999', 'G: 130,000 - 149,999'); Bitmap indexes can … Query Using Bitmap Indexes Description of \"Figure 6-1 Executing a Query Using Bitmap Indexes\" How … to Determine Candidates for Using a Bitmap Index Bitmap
Cardinality → The advantages of using bitmap indexes are greatest for columns in which the ratio of the number of … a bitmap index. However, data warehouse administrators also build bitmap indexes on columns with … unique). The majority of indexes in a data warehouse should be bitmap
Choosing Between Local Indexes and Global Indexes → (for example, a unique index on a non-partitioning key, or a performance requirement). Bitmap indexes on partitioned tables are always local. … B-tree indexes on partitioned tables can be global or local. With Oracle8 i and earlier releases … , Oracle recommended that global indexes not be used in data warehouse environments
Index the Correct Tables and Columns → (good for regular indexes). There is a small range of values (good for bitmap indexes). The column … for joins. Note: Primary and unique keys automatically have indexes, but you might want to create an … index on a foreign key. Small tables do not require indexes. If a query is taking too long, then
Table Compression and Bitmap Indexes → If you want to use table compression on partitioned tables with bitmap indexes, you need to do the … following before you introduce the compression attribute for the first time: Mark bitmap indexes … existing bitmap indexes or mark them UNUSABLE prior to adding a compressed partition.