title: SQL Select Query Timing Out
body: <p>I have a table in my SQL Server 2008 database called <strong>dbo.app_additional_info</strong> which contains approximately 130,000 records. Below shows the structure of the table.</p>
  
  <p><img src="https://i.stack.imgur.com/DLmyN.png" alt="enter image description here"></p>
  
  <p>When I run a query like the one below in SQL Server Management Studio 2008</p>
  
  <pre><code>select app_additional_text
  from app_additional_info
  where application_id = 2665 --Could be any ID here
  </code></pre>
  
  <p>My query takes a long time to execute (up to 5minutes) and sometimes it times out. This database is also connected to a Web Application and when it runs the above query, I always get a timeout error.</p>
  
  <p>Is there anything I can do to speed up the performance of my query? </p>
  
  <p>Your help with this would be greatly appreciated as this is grinding my web application to a halt.</p>
  
  <p>Thanks.</p>
  
  <p><strong>Update</strong></p>
  
  <p>Below shows my execution plan from SSMS (I apologise for poor quality)</p>
  
  <p><img src="https://i.stack.imgur.com/xEnit.png" alt="enter image description here">
  <img src="https://i.stack.imgur.com/iMb8K.jpg" alt="enter image description here"></p>