You need a toolbox such as Ibexpert, IBadmin, DBManager Professional, etc..
Look at the main IBphoenix.com web page.
Ibexpert, for example, shows all the dependencies, indexes used, statement
plan, etc. at the click of a button.

On Fri, 27 Nov 2009 08:45:45 +0100, PenWin <penwin@...> wrote:
> Hi!
>
> In my quest to deactivate unneeded indexes I encountered a problem:
> Stored procedures (and possibly triggers) are compiled to use these
> indexes and apparently they don't like it when I delete (or deactivate)
> those indexes ("index unexpectedly deleted" - Firebird 1.5). At the
> moment it seems that I will have to drop and re-create all procedures to
> solve this problem. Isn't there an easier solution? For example, if I
> could somehow get a list of indexes used by a procedure, I could match
> it against my list of indexes to delete and drop/create only procedures
> that need it.
>
> Thanks,
>
> Pepak
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>