Subject Re: [ib-support] How do I tell where a index is in use? (Resubmit)
Author Milan Babuskov
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.


Milan Babuskov