Tag Archives: DW
Oracle Bitmap Index
Common usage of Bitmap Indexes is a data warehousing environment. This implies large amounts of data, high level of ad-hoc queries but a low level of concurrent DLM transactions. Why to use? reduced response time reduced storage requirements compared to other … Continue reading
Oracle: Partitioning and Indexes
As I’ve been presenting in the last couple of posts on partitioning, one of the major benefits of this database option is basically the selectivity when filtering on the partition key, what we currently call partition pruning. Now, what we’ve … Continue reading
Oracle: Partition by List Sub-Partition by Range– Example
The following post will walk you trough an exercise of creating a partitioned table, using the list partitioning, with range sub-partitioning (explicit definition of partitions and sub-partitions naming), populating and testing the partition pruning. Please note I will also post … Continue reading
Working with Large Data Volumes – Partitioning
As more and more the increase in information is getting visible to each database user, there comes a question on how are we to process these volumes in a Data Warehouse environment. One of the first answers provided by Oracle … Continue reading
Oracle: Partition by Range– Example
The following post will walk you trough an exercise of creating a partitioned table, using the range partitioning (with auto define of partition names), populating and testing the partition pruning. Please note I will also post the scripts at each section so … Continue reading
Oracle: Partition by List – Example
The following post will walk you trough an exercise of creating a partitioned table, using the list partitioning, populating and testing the partition pruning. Please note I will also post the scripts at the end of the post, so you … Continue reading
Slowly Changing Dimensions – explained
Overview In discussing Slowly Changing Dimension, the first thing you must consider is first of all, your attributes type. Base on this, you will have various SCD types or combination of types. Dimension Attribute Types: Type 0: dimension attribute that … Continue reading
