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


Database Concepts, 12c Release 1 (12.1)

Indexes and Index-Organized Tables

Overview of Bitmap Indexeskey_compression clause of CREATE INDEX Overview of Bitmap Indexes In a bitmap index, the database … row. In a bitmap index, each index key stores pointers to multiple rows. Bitmap indexes are primarily … learn how to use bitmap indexes for performance

Database Concepts, 12c Release 1 (12.1)

Indexes and Index-Organized Tables

Example: Bitmap Indexes on a Single Table, whereas cust_id and cust_last_name do not. Thus, bitmap indexes may be appropriate on cust_marital_status … : Bitmap indexes can include keys that consist entirely of values, unlike B-tree indexesindexes can process this query efficiently by counting the number of 1 values in the

Database SQL Tuning Guide, 12c Release 1 (12.1)

Reading Execution Plans

Viewing Bitmap Indexes with EXPLAIN PLANand schedules the parallel plan appearing below it in the plan tree. Viewing Bitmap Indexes with … EXPLAIN PLAN Index row sources using bitmap indexes appear in the EXPLAIN PLAN output with the word … EXPLAIN PLAN with Bitmap Indexes In this example, the predicate c1 = 2 yields a bitmap

Database SQL Tuning Guide, 12c Release 1 (12.1)

Guidelines for Indexes and Table Clusters

Guidelines for Using Bitmap Indexes for PerformanceBitmap indexes can substantially improve performance of queries that have all of the following … columns. The tables in the queries contain many rows. You can use multiple bitmap indexes to evaluate the … conditions on a single table. Bitmap indexes are thus highly advantageous for complex

Database Data Warehousing Guide, 12c Release 1 (12.1)

Data Warehousing Optimizations and Techniques

About Cardinality and Bitmap IndexesThe advantages of using bitmap indexes are greatest for columns in which the ratio of the number of … for a bitmap index. However, data warehouse administrators also build bitmap indexes on columns with … almost unique). The majority of indexes in a data warehouse should be bitmap

Database Data Warehousing Guide, 12c Release 1 (12.1)

Data Warehousing Optimizations and Techniques

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 column limitations. See Also: Four Join Models for Bitmap Join Indexes in Data

Database Data Warehousing Guide, 12c Release 1 (12.1)

Data Warehousing Optimizations and Techniques

About Using Bitmap Indexes in Data WarehousesBitmap indexes are widely used in data warehousing environments. The environments typically have … the indexes can be several times larger than the data in the table. Bitmap indexes are typically only … regular index. Bitmap indexes store the bitmaps in a compressed

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Access Paths

Bitmap Index Access Pathsindexes combine the indexed data with a rowid range. This section explains how bitmap indexes, and … of multiple indexes retrieves all data requested by the query, without requiring table access. The … cost of retrieving rows from the table is higher than reading the indexes without retrieving rows

XML DB Developer's Guide, 12c Release 1 (12.1)

JSON in Oracle Database

39.7.2 Creating Bitmap Indexes for Oracle SQL Condition JSON_EXISTSYou can create a bitmap index for the value returned by json_exists. This is the right kind of … and false). This is illustrated by Example 39-20. Example 39-21 creates a bitmap index for a value … field CostCenter in your data. Example 39-20 Creating a Bitmap Index for JSON_EXISTS CREATE BITMAP … , '$.ShippingInstructions.Address.zipCode'));

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.1 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, 12c Release 1 (12.1)

Indexes and Index-Organized Tables

Unique and Nonunique Indexeswhich all key columns are , except for bitmap indexes or when the cluster key column value is . … Indexes can be unique or nonunique. Unique indexes guarantee that no two rows of a table have … in the leaf blocks is sorted only by key. Nonunique indexes permit duplicates values in the indexed

Database Concepts, 12c Release 1 (12.1)

Indexes and Index-Organized Tables

Types of Indexes\". Bitmap and bitmap join indexes In a bitmap index, an index entry uses a bitmap to point to multiple … for the join of two or more tables. See \" Overview of Bitmap Indexes \". Function-based indexes This … function, or included in an expression.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.2 Guidelines for Managing Indexesinformation about bitmap indexes Oracle Database Data Cartridge Developer's Guide for information about … You can follow guidelines for managing indexes. See Also: Oracle Database Concepts for conceptual … information about indexes and indexing, including descriptions of the various indexing schemes

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.2.12 Understand When to Create Multiple Indexes on the Same Set of Columns) systems with many concurrent transactions, while bitmap indexes are often used in data warehousing … You can create multiple indexes on the same set of columns when the indexes are different in some … way. For example, you can create a B-tree index and a bitmap index on the same set of columns. When

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.3.9 Creating an Unusable Indexindex. Note: Advanced index compression is not supported for bitmap indexes or index-organized tables … compression is most useful for non-unique indexes with a large number of duplicates on the leading … : Creating Indexes. See Also: Oracle Database SQL Language Reference Oracle Database Concepts for a … non-unique

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.2.2 Index the Correct Tables and Columnsis a small range of values (good for bitmap indexes). The column contains many s, but queries … 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 table might have grown from … relatively

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Access Paths

Table 8-4 Bitmap Index EntriesPurpose of Bitmap Indexes Bitmap indexes are suitable for low distinct cardinality data that is … candidate for bitmap index access. Through compression techniques, bitmap indexes can generate many … rowids with minimal I/O. Bitmap indexes

Database Concepts, 12c Release 1 (12.1)

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 Concepts, 12c Release 1 (12.1)

Indexes and Index-Organized Tables

Bitmap Join Indexesand the foreign key columns in the fact table. Bitmap join indexes are sometimes much more efficient … : Oracle Database Data Warehousing Guide for more information on bitmap join indexes … A bitmap join index is a bitmap index for the join of two or more tables. For each value in a

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Table Compression and Bitmap Indexes

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