Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 28 of 220
Parameter type |
Integer |
Default value |
|
Parameter class |
Static |
Range of values |
Operating system-dependent |
CREATE_BITMAP_AREA_SIZE
is relevant only for systems containing bitmap indexes. It specifies the amount of memory (in bytes) allocated for bitmap creation. The default value is 8 MB. A larger value may speed up index creation.
Cardinality is the number of unique values in a column in relation to the number of rows in the table. If cardinality is very small, you can set a small value for this parameter. For example, if cardinality is only 2, then the value can be on the order of kilobytes rather than megabytes. As a general rule, the higher the cardinality, the more memory is needed for optimal performance.
See Also:
Oracle9i Database Performance Guide and Reference for more information on using bitmap indexes |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|