title: Comparing stored procedure performance ex and new version
body: <p>I did create two new indexes on the tables that are used on a the sp. 
  The new results shows that on the part of problematic joins, the scans are converted to seek. I think seek is better rather than scan operations. On the other hand, the time takes more or less the same duration as it was without new indexes.</p>
  
  <p>So clearly, how can i get satisfied before putting my new version sp to production.</p>
  
  <p>For instance, changing parameters of sp can help me to see if the new version faster than old version or what else?</p>
  
  <p>Regards
  bk</p>