Recent Comments
Tag Archives: DW
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
Posted in DW
Tagged big data, DW, large data sets, Oracle, partition by list, partition by range, partition example, partition pruning, partitioning
Leave a comment
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
Posted in DW
Tagged big data, DW, large data sets, Oracle, partition by range, partition example, partition pruning, partitioning
1 Comment
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
Posted in DW
Tagged big data, DW, large data sets, Oracle, partition by list, partition example, partition pruning, partitioning
2 Comments
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
