title: Do triggers decreases the performance? Inserted and deleted tables?
body: <p>Suppose i am having stored procedures which performs Insert/update/delete operations on table.</p>
  
  <p>Depending upon some criteria i want to perform some operations. </p>
  
  <p>Should i create trigger or do the operation in stored procedure itself.</p>
  
  <p>Does using the triggers decreases the performance?</p>
  
  <p>Does these two tables viz <strong>Inserted</strong> and <strong>deleted</strong> exists(persistent) or are created dynamically?</p>
  
  <p>If they are created dynamically does it have performance issue.</p>
  
  <p>If they are persistent tables then where are they?</p>
  
  <p>Also if they exixts then can i access <strong>Inserted</strong> and <strong>Deleted</strong> tables in stored procedures?</p>