Re: Using Triggers to Maintain a Table to prevent complex join statements...

[Jay Pipes]

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