Message-Id: <10611.116282@fatcity.com> From: Ronen Levit Date: Wed, 6 Sep 2000 12:15:47 +0200 Subject: Secondary index on index-organized table - Too large I've created an IOT with a secondary index. Seems that the secondary index gets as much disk space as the whole table itself - which is amazing I think. The table consists 10 columns, while the 2nd index consists 2. Below you'll find the numbers ... Anyone knows how to reduce it's size? if possible?! (We're using direct load from 4 threads to insert data into this table, 8.1.5.1 on NT). Ronen Levit Database group manager Talmai Tel: +972 8 9460606 #212 Fax: +972 8 9460705 Cell: +972 52 448699 > TABLE TOTAL UNUSED USED > TOTAL UNUSED USED %USED > NAME BLOCKS BLOCKS BLOCKS > BYTES BYTES BYTES > ------------------------------ ------ ------ > ------ ----- ----- > ----- ----- > RT_PK ( IOT ) 768000 104448 663552 > 6291456000 855638016 5435817984 0.86 > (secondary index) 640000 0 640000 > 5242880000 0 5242880000 1