By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

MDC Rollout

P: n/a
Hi folks,

I have a MDC organized by (Date, ... other Dims) and a PK on this MDC like
(F1, F2, F3, DATE).
Select * from MDC where Date = ? picks up the BID index.

Why does DELETE from MDC where Date = ? strangely picks up the PK RID index
?

Couldn't the optimizer favor BID index for such trivial predicates,
especially when DB2_MDC_ROLLOUT=YES ?

Kind regards,

JM
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.