Why don't you add all the indecies in one alter table command?
Brent Baisley wrote:
You can probably monitor the database directory to see when the
temporary file disappears or the index file size stops changing. Then
it won't matter if the script dies again or not, you just need to keep
trac
You can probably monitor the database directory to see when the
temporary file disappears or the index file size stops changing. Then it
won't matter if the script dies again or not, you just need to keep
track of which indexes have already been built.
On Friday, January 17, 2003, at 08:30 AM,
> Hi,
>
> I need some guidance to the following problem.
>
> We have a really big table that crashed. We decided to rebuild the
> indexes so we stripped all the indexes and started a perl script that
> issued commands to build one index at a time. No the problem is that the
> shell where we star
