View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 05:50 AM
Jay Pipes
 
Posts: n/a
Default Re: Using Triggers to Maintain a Table to prevent complex join statements...

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
Reply With Quote