Tag Archives: big data

Oracle Indexing

Indexing is one of the most frequent approaches when resolving query performance issues raised within a database (though not necessary the right approach, but we can pick this up later). However, in order to better use indexing strategies, we should … Continue reading

Posted in DW, Indexing, Oracle DB Intro | Tagged , , , , , , , , , , | Leave a comment

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

Posted in DW | Tagged , , , , , , , , , | 3 Comments

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 , , , , , , , , | 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 , , , , , , , | 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 , , , , , , , | 2 Comments