Archives of the TeradataForum

Message Posted: Fri, 22 Feb 2002 @ 22:00:04 GMT

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

Ruth,

Normally, with large tables, I like breaking my queries into smaller pieces. For instance:

-if possible, change PI of 1.5billionrowtable to (NUPI = Col1, Col2) - make sure it is a multiset

-Create multiset keytable1 (NUPI=Col1) which needs to contain the distinct combinations of Col1 and Col2 from 1.5billionrowtable

-Join calendartable (make sure this table is duplicated to all amps in the Explain plan - force it if you have to) and 1.5millionrowtable to keytable1 and stores results in stagtable1 (UPI = calendartable.Col1, 1.5millionrowtable.Col2) including any addition attribute or fact columns needed

-Join 1.5billionrowtable to stagtable1 on Col1,Col2 (should be an AMP local merge join)

If you give me more detail, I might be able to give you a better alternative.

Thanks,

Claybourne Barrineau

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