Archives of the TeradataForum

Message Posted: Mon, 25 Oct 2004 @ 17:31:28 GMT

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

Regds,

With the use of check constraints, the optimizer will only scan the required tables assuming the check constrain exists in the table (for instance, if month were part of your transaction table, and you placed a constraint on the month column, then (assuming you specified were month = 6, then the optimizer would ignore the other 11 tables and only scan the table with a check constraint of month = 6.) If you have to join to another table inorder to resolve days to months, then this feature will not work.

Another option would be to merge all twelve tables into a single table, add the month column (if it does not already exist), and use month as the partitioning column.

Hope this helps,

Clay

Claybourne L. Barrineau
Senior Application DBA
Coca-Cola Enterprises, Inc.

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