Yes and no - it depends on the basic
layout of the data structures you have to handle.
So basically first comes the table layout then the transformation/transaction scheme. An index more or less could be...
- it will be showed by a testcase with mass - data, isn't it?
But indexes are independ of triggers and procedures.
yours
Claus

---------- Original Message ----------------------------------
From: "Robert DiFalco" <rdifalco@...>
Reply-To: firebird-support@yahoogroups.com
Date: Sat, 7 Aug 2004 13:36:14 -0700

>I'm assuming you would have a performance increase if you added indices
>after creating the stored procedure or trigger that they could take
>advantage of. Otherwise nothing?
>
>________________________________
>
>From: Claus Heeg [mailto:heeg.c@...]
>Sent: Saturday, August 07, 2004 9:32 AM
>To: firebird-support@yahoogroups.com
>Subject: Re: [firebird-support] Recompiling Triggers and Procedures?
>
>
>Now after 12+ more year using interbase I cannot recall
>any situation to recompile procedures or triggers ...
>beside a corruption or damage of tables.
>and I do't think this will be next years...
>Claus
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>