Archives of the TeradataForum

Message Posted: Fri, 07 Sep 2001 @ 15:33:17 GMT

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

Thanks to those that replied.

I was looking for an easy way of determining Raw data either at the system level or database level. There are far too many tables to look at individually.

What I ended up doing to going back to our ARCHIVE jobs and pulling out the information from there. The bytes and rows archived that are reported are valid and do not include the bytes for the indexes.

What I did find interesting was the amount of space being used by my indexes. On some tables with 3 NUSI, the space used was another 80% more! Something I'll have to investigate.

Ruth Fenwick
IA&DSS Team Leader
Information Resource Management
Hudson's Bay Company

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