I have some large tables (over 100M rows on a non-partitioned
database) that each have at least one good candidate for an MDC
dimension. Am I right in assuming that if a query referencing an MDC
table contains two predicates, one on the MDC dimension, and the other
referencing a column in a RID index, the optimizer will only use the
RID index to examine pages within qualifying MDC extents/blocks?
Without MDC, I've often needed to include a commonly searched column
in multiple indexes in order to flexible searches. My plan for MDC is
to reduce the cost of ...