Recently I got a question:
We are thinking to use partitioning for our DW database, since we have monthly incoming data of 30 million rows and partitioning will make the reads and writes much faster; we are using a 2 CPU machine with 16 Gb, 2 hard drives of 500Gb each.
Could you recommend a good strategy
Continue reading […] Can partitioning solve it all? […]
There is no magic in indexes. Instead, it is all about timing and balance.
A few quick word on index structures – nothing deep here, I am sure if you are reading this, you already know enough about index structures:
indexes are organized in B-trees, i.e. leaf structures comprised of hierarchical pages, pointing to each other
Continue reading […] Total index maintenance […]