Re: How to see progress on long index ops

2001-12-21 Thread Steve Rapaport
Thanks, that works! (By the way, my current index has another day and a half to go!) steve Dan Nelson wrote: >In the last episode (Dec 22), Steve Rapaport said: > >>I've got a "Alter table DROP INDEX" that's been running for over 48 >>hours now. I'm hoping to load a bunch of tables in a new

Re: How to see progress on long index ops

2001-12-21 Thread Dan Nelson
In the last episode (Dec 22), Steve Rapaport said: > I've got a "Alter table DROP INDEX" that's been running for over 48 > hours now. I'm hoping to load a bunch of tables in a new database > with 22 million records, and then create the indexes afterwards, but > if this creation takes days, I reall

How to see progress on long index ops

2001-12-21 Thread Steve Rapaport
I've got a "Alter table DROP INDEX" that's been running for over 48 hours now. I'm hoping to load a bunch of tables in a new database with 22 million records, and then create the indexes afterwards, but if this creation takes days, I really want to know if it is working or not, and how far it h