Monthly Archives: May 2020

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 Function Based Index

What is a Function-Based Index? A function-based index is an index created on the result of a function or expression. This type of index is more used for situations with atypical searches on the specified columns (e.g. search on an … Continue reading

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