1.

What are the advantages of MDC tables?

Answer»

First, MDC enables a table to be physically clustered on more than one key, or dimension, simultaneously. As a result query performance is improved where there is a clustering of one or more specified dimensions of a table. CONSEQUENTLY not only will these QUERIES access only those PAGES having records with the correct dimension values, but these qualifying pages will ALSO be grouped into blocks, or extents.

Second, although a table with a clustering index can become unclustered over time, in most cases an MDC table is able to maintain and guarantee its clustering overall dimensions automatically and continuously.

Third, in MDC the clustering INDEXES are block-based. These indexes are much smaller than regular record-based indexes, hence they take up much less disk space and are faster to scan.


Discussion

No Comment Found

Related InterviewSolutions