RE: tunning an index build

From: Hallas, John (EXP N-ARM) <john.hallas_at_lmco.com>
Date: Wed, 18 Jul 2007 08:50:23 +0100
Message-id: <4C623E38629BDA469E90D1FF271309E9106FF3F1@emss51m09.uk.lmco.com>

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 - 02:50:23 CDT