RE: tunning an index build
- From: genegurevich@xxxxxxxxxxxx
- To: "Hallas, John (EXP N-ARM)" <john.hallas@xxxxxxxx>
- Date: Wed, 18 Jul 2007 10:33:17 -0500
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@lmco To
.com> genegurevich@xxxxxxxxxxxx,
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
genegurevich@xxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
