Archives of the TeradataForum
Message Posted: Tue, 04 Jul 2006 @ 16:05:34 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|