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 bitmap indexes


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


Database Concepts

Indexes and Index-Organized Tables

Bitmap Indexesmultiple rows. Bitmap indexes are primarily designed for data warehousing or environments in which queries … these rows. For this reason, bitmap indexes are not appropriate for many OLTP applications. See Also … : Oracle Database Performance Tuning Guide to learn how to use bitmap indexes

Database Performance Tuning Guide

Using Indexes and Clusters

14.5 Using Bitmap Indexes for PerformanceBitmap 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

Database Performance Tuning Guide

Using EXPLAIN PLAN

12.7 Viewing Bitmap Indexes with EXPLAIN PLANIndex 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

Database Data Warehousing Guide

Indexes

Bitmap Indexes and NullsHow to Determine Candidates for Using a Bitmap Index Bitmap indexes should help when either the … likely. Bitmap Indexes and Nulls Unlike most other types of indexes, bitmap indexes include rows that … joined with two or more dimension tables, and there

Database Data Warehousing Guide

Indexes

Bitmap Indexes on Partitioned TablesYou 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

Database Data Warehousing Guide

Indexes

Using Bitmap Indexes in Data WarehousesBitmap 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

Database Data Warehousing Guide

Indexes

Using Bitmap Join Indexes in Data Warehousesindex on the join column. Bitmap join indexes are much more efficient in storage than materialized … views do not compress the rowids of the fact tables. B-tree and bitmap indexes have different maximum … In addition to a bitmap index on a single table, you can create a bitmap join index,

Database Performance Tuning Guide

The Query Optimizer

Enables the optimizer to cost a star transformation for star queries if true. The star transformation…See Also: Oracle Database Reference for complete information about each initialization parameter

Database Administrator's Guide

Managing Indexes

About IndexesOracle 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.

Database Concepts

Indexes and Index-Organized Tables

Table 3-2 Sample Bitmap… Note: Bitmap indexes can include keys that consist entirely of values, unlike B-tree indexes … '); Bitmap indexes can process this query efficiently by counting the number of 1 values in the resulting … converts each bit in the bitmap to a rowid of the customers table. Each

Database Administrator's Guide

Managing Indexes

Guidelines for Managing IndexesWarehousing Guide for information about bitmap indexes Oracle Database Data Cartridge Developer's Guide for … 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

Database Data Warehousing Guide

Physical Design in Data Warehouses

Indexes and Partitioned Indexes-tree indexes, bitmap indexes are very common in data warehousing environments. Bitmap indexes are … Indexes are optional structures associated with tables or clusters. In addition to the classical B … optimized data access methods such as star transformations. Indexes

Database Concepts

Indexes and Index-Organized Tables

Secondary Indexes on Index-Organized Tablesunique scan of the index organized table by primary key value. Bitmap Indexes on Index-Organized … Indexes\", a bitmap index stores a bitmap for each index key. When bitmap indexes exist on an index … -organized table, all the bitmap indexes

Database Administrator's Guide

Managing Tables

Creating Secondary Indexes on Index-Organized Tablessecondary indexes, and bitmap indexes are supported as secondary indexes on index-organized tables … guesses, collect index statistics again. Bitmap Indexes Bitmap indexes on index-organized tables are … You can create secondary indexes

Database Administrator's Guide

Managing Indexes

Index the Correct Tables and Columnsregular indexes). There is a small range of values (good for bitmap indexes). The column contains … 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 the

Database Concepts

Glossary

bitmap mergeDOB columns have bitmap indexes, then the database may use a bitmap merge if the query predicate is WHERE gender='F' AND DOB > 1966. … An operation that merges bitmaps retrieved from bitmap index scans. For example, if the gender and

Database Data Warehousing Guide

Indexes

7 IndexesThis 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

Database VLDB and Partitioning Guide

Partitioning for Availability, Manageability, and Performance

Table Compression and Bitmap IndexesTo use table compression on partitioned tables with bitmap indexes, you must do the following … before you introduce the compression attribute for the first time: Mark bitmap indexes unusable. Set the … an existing, fully uncompressed partitioned table, you must either drop all existing bitmap indexes

Database Performance Tuning Guide

Using Indexes and Clusters

14 Using Indexes and ClustersIndex-Organized Tables for Performance Using Bitmap Indexes for Performance Using Bitmap Join Indexes … This chapter provides an overview of data access methods using indexes and clusters that can … Performance Using Function-based Indexes for Performance Using Partitioned Indexes

Database Data Warehousing Guide

Indexes

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 7-1 Executing a Query Using Bitmap Indexes\" … cust_id 130 1 0 cust_id 140 1 0 Each entry (or bit) in the bitmap corresponds