Subject RE: [ib-support] How do I tell where a index is in use? (Resubmit)
Author Michael L. Horne

I had already disconnected all users, finally I started removing Stored
did all them and still could not drop the index, so I started removing
and after removing one of them I was allowed to drop the index. It sure
be nice to be able to tell where a index is in use.

Michael L. Horne

> -----Original Message-----
> From: Milan Babuskov [mailto:milanb@...]
> Sent: Monday, December 16, 2002 1:05 PM
> To:
> Subject: Re: [ib-support] How do I tell where a index is in use?
> (Resubmit)
> Michael L. Horne wrote:
> > Hello,
> >
> > I have decided to drop an index from one of the tables in
> > my db, but I am told it is in use. How do I determine which
> > stored procedure or trigger is using the index without deleting
> > all of them?
> This looks like the index is in use at the moment. Try disconnecting all
> users from database and connect then and drop index.
> HTH.
> Milan Babuskov