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