Cory Robin wrote:
> We have a statement that joins 8 different tables to pull
> multiple rows from each table.
>
> I have heard of people using triggers to create, update and
> delete records in a table based on statements in other
> tables.
>
> The obvious result of this would be to SPEEEEEED up results
> right? 
>
> I'd love to find someone with experience with this that I
> can pick info from. lol
Post the SQL you are using and I'll give you a hand.
Cheers!
Jay