Database Partitioning, Table Partitioning, and MDC for DB2 9
Aug 2008 · IBM Redbooks
4.6star
17 reviewsreport
Ebook
264
Pages
family_home
Eligible
info
reportRatings and reviews aren’t verified Learn More
About this ebook
As organizations strive to do more with less, DB2 Enterprise Server Edition V9 for Linux, Unix, and Windows contains innovative features for delivering information on demand and scaling databases to new levels. The table partitioning, newly introduced in DB2 9, and the database partitioning feature provide scalability, performance, and flexibility for data store. The multi-dimension clustering table enables rows with similar values across multiple dimensions to be physically clustered together on disk. This clustering allows for efficient I/O and provides performance gain for typical analytical queries.
How are these features and functions different? How do you decide which technique is best for your database needs? Can you use more than one technique concurrently?
This IBM Redbooks publication addresses these questions and more. Learn how to set up and administer database partitioning. Explore the table partitioning function and how you can easily add and remove years of data on your warehouse. Analyze your data to discern how multi-dimensional clustering can drastically improve your query performance.
Ratings and reviews
4.6
17 reviews
Lansana Kabbah
- Flag inappropriate
February 26, 2018
The book is educative
1 person found this review helpful
rehaan thakur
- Flag inappropriate
July 17, 2014
1S17 q
Rate this ebook
Tell us what you think.
Reading information
Smartphones and tablets
Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.
Laptops and computers
You can listen to audiobooks purchased on Google Play using your computer's web browser.
eReaders and other devices
To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.
