title: Performance in sql
body: <p>So i got one select from view and two tables, long story short,</p>
  
  <p><strong>first execution is ok, less than 1s, after first execution i lost performance, execution last about 30s</strong> </p>
  
  <p>trick - after i change string add '(space)' or take off(somewhere in select) performance first execution is again 1s and second or more is 30s</p>
  
  <p>exec plan i guess is the same first and second+ time execution...</p>
  
  <p>Question - whats happening?</p>
  
  <p>cache?</p>
  
  <p>Yes, tried to rewrite in 5 another ways same, 30 seconds if more then one execution,if not changing select adding ' ' or take it off.</p>
  
  <p>hope someone can help me :)</p>
  
  <p>Best regards</p>