Archives of the TeradataForum
Message Posted: Wed, 23 Mar 2005 @ 06:24:03 GMT
Since this appears to be cross posted from www.teradata.com I will respond here as well.
Showblocks from Ferret and a little math.
start ferret from the supervisor window of DBW.
in the ferret window type
scope table "mydatabase.mytable" 0
The Quotes are required. Single / double doesn't matter as long as they match. Substitute your own database and table name.
It is a Very WIDE display.
The 0 table are the collective table headers from all the amps.
the 1024 table is the primary data table.
1028 , 1032, 1036 .... are the Secondary index tables. They should correspond to the order of the indexes displayed from Show table.
the 2048, 3072, 4096 ... tables are the Fall back copies of the Primary data table.
the 2052, 2056, 3076, 3080 .... tables are the fall back copies of the Secondary indexes.
find the line that corresponds to your index.
Column 19 of the display is the Average Datablock size. ( in 1/2 k sectors )
Column 21 is the number of Datablocks.
Multiply the two numbers. You will have the size of your index in sectors.
Divide that by 2 to get Kilobytes
Divide that by 1024 to get Megabytes
Divide that by 1024 to get Gigabytes
Divide that by 1024 to get Terabytes.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|