Thanks for the info. I'd hate to imagine the performance problems that could
result if you didn't know you had to rebuild the indexes.
Regards,
Mike
"W. Breitling" <breitliw_at_centrexcc.com> wrote in message
news:22165e0a.0311170747.610e1bff_at_posting.google.com...
> To be precise, indexes are not 'INVALID' after an "alter table ...
> move" of the underlying table, they are 'UNUSABLE'
>
> "Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
news:<vrfin9g9l1mt08_at_corp.supernews.com>...
> > Check the status of the indexes after the MOVE.
> > You will see that they are invalid.
> > You will either need to rebuild them, or drop and recreate them.
> >
Received on Mon Nov 17 2003 - 19:25:35 CST
