My Cart
Bookstore Sign In
Books
Advertising
Art
Biographies & Memoirs
Business & Economics
Business & Investing
Cards, Greeting Cards, Card Decks
Children's
Constitution
Education
Entertainment
Family
Film Production
Fitness & Nutrition Journals
Food & Wine
Grief & Bereavement
Health, Mind & Body
History
Literature & Fiction
Mathematics
Music
Reference
Religion & Spirituality
Self Help
Self-Improvement
Sports
CDs & DVDs
Constitution
Education
Food & Wine
Health, Mind & Body
Literature & Fiction
Music
Parenting & Families
Self-Improvement
Publishing Samples
Technical Manuals
Altova
IBM Redbooks
Juniper Networks
Menu
Database Partitioning, Table Partitioning, and MDC for DB2 9
IBM Redbooks
ADD TO CART
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.
Price:
$37.50
Pages:
264
Date Published:
August 27, 2008
ISBN:
0738489220
Author:
IBM Redbooks
Product Number:
SG24-7467-00
Ships in 3-5 days
ADD TO CART
X Close
Why Vervante?
© 2024 Vervante Corporation. All rights reserved.