Archives of the TeradataForum

Message Posted: Tue, 27 Apr 2004 @ 12:11:17 GMT

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

Actually all I need is to find out how I can get the size of all the indexes in our system.

From What I was told, primary indexes do not take much space, if any. We can drop the secondary index in a table and then compare the size of the table to when it had the secondary index. But this would be a very tedious task to do for ALL our table. Does anyone know of a trick to come up with this? may be a script against the data dictionary?

Thanks,

Nazy

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