Skip to primary content
Skip to secondary content

Data Warehousing with Oracle

Dani Schnider's Blog

Data Warehousing with Oracle

Main menu

  • Home
  • Contact
  • About
  • Publications
  • Presentations

Monthly Archives: January 2015

How to Replace a Bitmap Index

Posted on 25. January 2015 by Dani Schnider
Reply

Bitmap indexes are typically used for columns with low cardinality, i.e. with a small number of distinct values. This is not always the best solution. The following use case describes a situation from a real-life project and explains why and how we replaced a bitmap index with a combination of virtual column and b-tree index.

Continue reading →

Posted in Oracle, Performance, SQL | Leave a reply

Avoid dbms_stats.auto_invalidate in ETL jobs

Posted on 6. January 2015 by Dani Schnider
2

Recently I realized that the dbms_stats parameter no_invalidate is important for statistics gathering in ETL jobs. I never considered this parameter because “the default value will be good enough” – as for most other parameters of the statistics gathering procedures. But in this case, this is obviously not true.

Continue reading →

Posted in ETL, Oracle, Performance | 2 Replies

Categories

  • ADWC (6)
  • Books (8)
  • Cloud (6)
  • Conferences (20)
  • Data Vault Modeling (20)
  • Dimensional Modeling (13)
  • DWH Architecture (16)
  • DWH Automation (4)
  • ETL (27)
  • In-Memory (5)
  • Materialized Views (6)
  • Oracle (82)
  • Oracle 12c (27)
  • Oracle 19c (3)
  • Oracle 20c (1)
  • Oracle Data Integrator (1)
  • Oracle OpenWorld (8)
  • Oracle Warehouse Builder (7)
  • Partitioning (20)
  • Performance (50)
  • PL/SQL (9)
  • Relational Modeling (3)
  • Snowflake (1)
  • SQL (45)

Archives

  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • February 2022
  • December 2021
  • January 2021
  • December 2020
  • November 2020
  • June 2020
  • April 2020
  • February 2020
  • December 2019
  • October 2019
  • July 2019
  • June 2019
  • April 2019
  • March 2019
  • February 2019
  • December 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • April 2015
  • March 2015
  • January 2015
  • December 2014
  • October 2014
  • August 2014
  • July 2014
  • June 2014
  • October 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013
  • June 2012
  • May 2012
  • January 2012
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
Blog at WordPress.com.
  • Follow Following
    • Data Warehousing with Oracle
    • Join 125 other followers
    • Already have a WordPress.com account? Log in now.
    • Data Warehousing with Oracle
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar