That's an awfully strange extent size (514k). Why don't you make it bigger, and make
it divisible by your database block size? This would reduce wasted space. Also, do
you really need all 8 columns indexed? If it's just for performance, you might be
able to get away with using fewer columns
Aren't you running out of extents because your initial and next extent size
is so small? I would increase the extent size at least to the block size or
a multiple of the block size.
-Original Message-
Sent: Wednesday, April 11, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L
Hi,
Hi, Leslie,
1. First of all, if you are on 8i, I'd strongly consider index compression
CREATE INDEX INX ON TAB(N,M,...) COMPRESS .
Depending on your data, I' set compression level up to 7. This would greatly
reduce index size.
2. as soon as 514K*4080/300 approx gives 700 byte I wonder, do you
You have to add another datafile to index tablespace and also increase the
temp tablespace size.
-Original Message-
Sent: Wednesday, April 11, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I need to build an index on a table of 80 columns with
3 million rows. The ind