Archives of the TeradataForum

Message Posted: Thu, 08 Jul 2010 @ 16:10:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

No, if the EXPLAIN says "n partitions" then you are getting partition elimination. Your question really seems to be about the number of partitions that will be referenced.

The fact that the number of partitions matches the number of dates when you specify both levels implies that all of your AREA_CODE values are being assigned to a single partition. The fact that the number of partitions is doubled when you specify only the date implies that you have exactly two AREA_CODE partitions for each date (e.g. one with all the values, and one for NO RANGE OR UNKNOWN).

If you really intended to define a separate partition for each (date, area_code) combination then double check your partitioning expression. For example, did you omit the EACH clause from RANGE_N?

	<Prev	Next>		<<First	<Prev	Next>	Last>>