Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 501 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

(Bishwaranjan Bhattacharjee, Sriram Padmanabhan, Timothy Malkemus, Tony Lai, Leslie Cranston and Matthew Huras) IBM's DB2 Universal Database version 8 for Unix, Windows, and open platforms introduces a new feature called Multi-Dimensional Clustering (MDC). Multi-Dimensional Clustering provides a flexible and orthogonal physical clustering organization for a relational table using one or more attributes of the table as dimensions of clustering. We have described the overview of MDC - including how the clustering is maintained over time. In this paper, we report on the query processing enhancements to DB2 for processing MDC tables efficiently.
(PDF)

 Read this article...
 Related Articles - For Members.
Second Normal Form (2NF)
SQL Server Temporary Tables Optimization Tips
Temporary Tables: Declared and Created
Primary Key Constraints and Clustered Indexes: The Same or Different?
Clustered and non-clustered indexes in SQL Server
Getting up to Speed with Indexes in SQL Server
An Introduction to Clustered and Non-Clustered Index Data Structures
Temporary tables in Microsoft® SQL Server™ 2000
SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes
SQL Server Interview Questions and Answers - Part 2



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004