Archives of the TeradataForum

Message Posted: Thu, 11 Jul 2002 @ 08:06:05 GMT

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

Keeping a separate copy of ResUsage tables also has other advantages...

-- you can add SI's as required (value ordered NUSI on THEDATE?)

-- you can make them NO FALLBACK to save disk space

-- you can reduce the size of the real ResUsage tables in DBC so making queries against these faster

-- and probably others.

(as you can probably tell !) I'm a big fan of doing this.

There's also no reason why you shouldn't take the same approach with some other DBC tables which also build up history.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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