RE: tunning an index build

From: <genegurevich_at_discover.com>
Date: Wed, 18 Jul 2007 10:33:17 -0500
Message-ID: <OF8FF0DDBD.123B79EE-ON8625731C.005560D7-8625731C.005570D4@discover.com>

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_at_lmco                                          To 
             .com>                     genegurevich_at_discover.com,          
                                       oracle-l_at_freelists.org              
             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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
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

Received on Wed Jul 18 2007 - 10:33:17 CDT