Ever wanted to find out how big are the tables in your data warehouse or in your ETL storage area? Here is a quick tip.
Ever wanted to find out how big are the tables in your data warehouse or in your ETL storage area? Here is a quick tip.
On my previous blog post B-tree vs Bitmap indexes – Indexing Strategy for your Oracle Data Warehouse I answered two questions related to Indexing: Which kind of indexes can we use and on which tables/fields we should use them. As I promised at the end of my blog, now it´s time to answer the third question: what are the consequences of indexing in terms of time (query time, index build time) and storage?
Some time ago we’ve seen how to create and maintain Oracle materialized views in order to improve query performance. But while materialized views are a valuable part of our toolbox, they definitely shouldn’t be our first attempt at improving a query performance.
In this post we’re going to talk about something you’ve already heard about and used, but we will take it to the next level: indexes. (more…)
Subscribe to our Blog
LinkedIn
Follow us on Twitter
YouTube Channel
© Copyright 2013 Clariba. All rights reserved.