online index build

Isaac Yassin

online index build
Hi,

What I'm really missing is an "online index build" .
Getting a window to do it can be very problematic.


Isaac Yassin
DBMS & IT Consultant
[login to unmask email]



Donna Di Carlo

Re: online index build
(in response to Isaac Yassin)
Hi Isaac,

Just out of curiosity, what prompts you to do an index rebuild? Is it
because of a REORG, LOAD, RECOVERY, other? How would you envision this
feature working?

Thanks,
Donna Di Carlo
BMC Software

-----Original Message-----
From: Isaac Yassin [mailto:[login to unmask email]
Sent: Thursday, January 11, 2001 12:48 PM
To: [login to unmask email]
Subject: online index build


Hi,

What I'm really missing is an "online index build" .
Getting a window to do it can be very problematic.


Isaac Yassin
DBMS & IT Consultant
[login to unmask email]








Isaac Yassin

online index build
(in response to Donna Di Carlo)
Hi Donna,
Let's start with simple "create index" when you need a new index, expand
that to "rebuild index" when you don't have an IC of it (due to any reason
of your choice), or a terminated "load" where you have to recover TS & its
IXs...

The main point is that any index build from the data is keeping us from
updating the data and that means "happy" users.

Isaac Yassin
DBMS & IT Consultant
[login to unmask email]