Archives of the TeradataForum

Message Posted: Tue, 04 Jul 2006 @ 16:05:34 GMT

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

Hi,

I'm trying to evaluate de size of the indices in all the databases of the system

My problme tuch essentialy the size of the 'SECONDARY INDEXES' and 'JOIN INDEX'

For me, there is Two methods :

- evaluate the size of the table before, drop the index and doing the substration between the 2 size. For me, in production it is impossible.

- doing a tendance with the evaluation of the size use in the index and the number of row for each table and finaly doing the sum... possible but long...

I want to find a function/macro or a request wich give me easily the good information.

Thanks for your information

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