Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 09:01:48 GMT

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

Geoffrey,

Let me guess that you have 28 nodes, or another multiple of 7. With a PI of date but no data for every Sunday, i.e. a gap of every seventh integer, that will be 4 nodes empty.

If proportionately more records are gathered on one day of the week than others, then another 4 nodes will easily achieve 1.26.

If the number of nodes is divisible by 7 then that spread will continue.

If you change the number of nodes then you have a better chance of circulating the non-working day and the peak day across all of the amps.

If changing the nodes is too drastic then consider another index, perhaps an extra column with a number for each working day of the year.

Ken Hansen

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