Is the table data sorted in any way. Can it be sorted?

Are you building these indexes (I should write indices I know but it
never seems right) regularly or just as a one off. If regularly then the
rebuild option should be much faster

John

-----Original Message-----
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)
genegurevich@(protected)
Hi all:

I think I have posted on this issue before, but I can't find my old
Emails
so - sorry for the repeated question.
Here is the situation. I am running oracle 9208 and have a 40G table
with
a lot of indices - mostly bitmap
Their sizes are under 1G. These indices take about 20 to 30 minutes to
build. That seems to be too long.


--
http://www.freelists.org/webpage/oracle-l