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 1879 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Concepts, 11g Release 1 (11.1)

Schema Objects

Bitmap Indexesindexes 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

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Index-Organized Tables

Bitmap IndexesBitmap indexes on index-organized tables are supported, provided the index-organized table is

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Overview of Bitmap Indexes in Data WarehousingBitmap 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

Database Concepts, 11g Release 1 (11.1)

Schema Objects

Bitmap Indexes on Index-Organized TablesOracle 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

Database Performance Tuning Guide, 11g Release 1 (11.1)

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, 11g Release 1 (11.1)

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, 11g Release 1 (11.1)

Indexes

Bitmap Indexes and NullsUnlike 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

Database Data Warehousing Guide, 11g Release 1 (11.1)

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, 11g Release 1 (11.1)

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 Administrator's Guide, 11g Release 1 (11.1)

About 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, 11g Release 1 (11.1)

Schema Objects

Overview of IndexesReverse key indexes Bitmap indexes Bitmap join indexes Oracle Database also provides support for function … Scan Index Range Scan Key Compression Reverse Key Indexes Bitmap Indexes Bitmap Join IndexesIndexes

Database Concepts, 11g Release 1 (11.1)

Schema Objects

Function-Based IndexesFunction-Based Indexes See Also: \"Bitmap Indexes\" Oracle Database Performance Tuning Guide for more … You can create indexes on functions and expressions that involve one or more columns in the table … in the index. You can create a function-based index as either a B-tree or a bitmap index. The

Database Concepts, 11g Release 1 (11.1)

Schema Objects

Indexes and Nullsindexes or when the cluster key column value is NULL. See Also: \"Bitmap Indexes and Nulls\" … NULL values in indexes are considered to be distinct except when all the non- NULL values in two or … . Therefore, UNIQUE indexes prevent rows containing NULL values from being treated as identical. This does

Database Administrator's Guide, 11g Release 1 (11.1)

Guidelines for Managing Indexes

Guidelines for Managing IndexesData 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

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Index-Organized Tables

Creating Secondary Indexes on Index-Organized Tablessecondary indexes, and bitmap indexes are supported as secondary indexes on index-organized tables. … You can create secondary indexes on an index-organized tables to provide multiple access paths … . Secondary indexes on index-organized tables differ from indexes on

Database Data Warehousing Guide, 11g Release 1 (11.1)

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, 11g Release 1 (11.1)

Schema Objects

Bitmap Join Indexestable. Bitmap join indexes are much more efficient in storage than materialized join views, an … compress the rowids of the fact tables. See Also: Oracle Database Data Warehousing Guide for more information on bitmap join indexes … In addition to a bitmap index on a single table, you can create a bitmap

Database Concepts, 11g Release 1 (11.1)

Very Large Databases (VLDB)

Miscellaneous Information about Creating Indexes on Partitioned TablesYou can create bitmap indexes on partitioned tables, with the restriction that the bitmap indexes … must be local to the partitioned table. They cannot be global indexes. Global indexes can be unique … . Local indexes can only be unique if the partitioning key is a part

Database Data Warehousing Guide, 11g Release 1 (11.1)

Indexes

6 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 Performance Tuning Guide, 11g Release 1 (11.1)

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