-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

The Definitive Guide to Data Integration
By :

As we continue our discussion of data modeling techniques, we will look at some advanced techniques that can help you further optimize your data architecture for analytics and reporting. Partitioning, bucketing, and Z-ordering are all techniques that can improve query performance and data organization in your system.
Indexing is a strategy for improving database query performance by establishing and maintaining a data structure (an index) that allows for faster data retrieval. Indexes on one or more columns of a table can be defined and can improve query performance. Indexes, on the other hand, have a cost in that they demand additional storage and might slow down data modification activities such as inserts, updates, and deletes. As a result, striking a balance between generating indexes for query efficiency and controlling the related overhead is critical.
Unlike indexing, partitioning does not require additional costs...