467,118 Members | 925 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,118 developers. It's quick & easy.

Coarsification of colums: not generated colums but row-value constructors in DB2 UDB

In

http://www-1.ibm.com/partnerworld/pw...st_052504.html

the writer says (page 50, Multidimensional Clustering Advisor):

"
The MDC Advisor feature of the DB2 Design Advisor recommends MDC
clustering dimensions, including coarsification on base colums in
order to improve workload performance
->This includes potentially recommending generated colums that
define coarsification of dismensions.
"

I will not discuss the neede of coarsification on itself. But if for
global performance/throughput a MDC is better not to be maintained,
then the answer to coarsification is row-value constructor with index
exploitation, a SQL-92 approach.

Coarsification with generated columns:

- adds storage overhead
- is artificial
- is not detected by programming interfaces as a special
column that needs to be treated on a special manner
- programmers will use the generated column directly

The designers of SQL-92 defined the row-value constructor because
there is a need.

The writer of the presentation confirms it.

Conclusion: in DB2 UDB (LUW) the optimizer decides about a query
handling, DB2 UDB programmers need full row-value constructur
implementation in DB2 UDB to close the semantic gap between what they
need to express and what the optimizer can understand.
Bernard Dhooghe
Nov 12 '05 #1
  • viewed: 1268
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Joy | last post: by
2 posts views Thread by Saurabh Sharma | last post: by
1 post views Thread by basulasz | last post: by
2 posts views Thread by baburk | last post: by
2 posts views Thread by sapsi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.