Performance Improvements

  • Albert Nogués
  • Juan Valladares
Chapter

Abstract

In a mid-sized company, it is highly possible that the volume of data we own is not that big. However, if we are a retail company, it is likely that our transactional can have a good amount of transactions, especially if we have several years of data. Whether that is the case of your business or not, it is important to have some exposure to improve performance when working with databases. This is the reason this chapter was added to the book: to provide you with some insights about how to speed up your processes. Whereas this is not a very extensive compilation, it should be enough to start.

Keywords

Tree Index Fact Table Retail Company Bitmap Index Range Partitioning 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Albert Nogués and Juan Valladares 2017

Authors and Affiliations

  • Albert Nogués
    • 1
  • Juan Valladares
    • 1
  1. 1.BarcelonaSpain

Personalised recommendations