Tag Archives: Oracle

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 Index Organized Table(IOT)

What is an IOT? An IOT implies having your entire table indexed, within the same B-Tree structure. Should be used for larger scale tables or dimensions, highly used within the database. How to? Accessing the data is done via the … Continue reading

Posted in DW, Indexing, Oracle DB Intro | Tagged , , , , | 1 Comment

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

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

Oracle Reverse Index

This is one of the least used Oracle indexes I’ve encountered in a data-warehousing environment. However, a very good instrument in performance problems on OLTPs. To understand a reverse key index, we must first look at the regular b-tree index … Continue reading

Posted in DW, Indexing | Tagged , , , , , , | Leave a comment

Cursor Loop Updates

I’m writing this topic mostly for database developer coming from the programming world. I have seen various procedural units which use the for syntax to run updates on base tables. Scenarios like the one bellow. FOR update SQL: for i … Continue reading

Posted in 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 , , , , , , , , , | 1 Comment

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