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

2007-02-21 Thread 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 SPEED up results right

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

2007-02-20 Thread Cory Robin
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 SPEED up results right? :) I'd love to f