The data are not sorted as far as I know. The indices are being dropped
daily and rebuilt after a batch load into
the table

thank you

Gene Gurevich



                                                 
        "Hallas, John                                
        (EXP N-ARM)"                                
        <john.hallas@(protected)
        .com>              genegurevich@(protected),      
                         oracle-l@(protected)        
        07/18/2007 02:50                             cc
        AM                                        
                                            Subject
                         RE: tunning an index build      
                                                 
                                                 
                                                 
                                                 
                                                 
                                                 




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