Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2003 @ 17:42:35 GMT


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


Subj:   Re: Primary index and table space
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, March 17, 2003 12:36 -->

Dave and Dieter,

Here are some more information.

Table sizes :  173,656,064
               173,657,088 (with more number of columns in PI)

Is this change in size only due to change in PI?

   No of rows:         1305873 (same data in both the tables)
   No of Amps:        10

Show block statistics :
+------------+----+----+----+----+----+----+----+----+----+----+
-+----+----+----+-----+
|            |                     Distribution of data block sizes
|   Data block    |   Total    |   Total   |
|            |                      (by range of number of sectors)
| size statistics |   Number   |   Number  |
|
+----+----+----+----+----+----+----+----+----+----+----+----+----+
---+    (sectors)    |     of     |     of    |
|  Table ID  |  1-|  2-|  4-|  8-| 16-| 32-| 48-| 64-| 80-|
96-|112-|128-|160-|192-|224-|-----+-----+-----+    Data   | Cylinders |
|            |  1 |  3 |  7 | 15 | 31 | 47 | 63 | 79 | 95 |111|127|159
|191 |223 |255 | Min | Avg | Max |   Blocks   |           |
+------------+----+----+----+----+----+----+----+----+----+----+----+
-+----+----+----+-----+
|    0 10442 |    |    |    |    |    |    |    |    |    |    |100%|
|    |    |    |   7 | 127 | 127 |       2675 |        96 |
|    0 10443 |    |    |    |    |    |    |    |    |    |    |100%|
|    |    |    |  24 | 127 | 127 |       2675 |        95 |
+------------+----+----+----+----+----+----+----+----+----+----+----+
-+----+----+----+-----+

Thanks



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016