title: indexing large table in SQL SERVER
body: <p>I have a large table (more than 10 millions records). this table is heavily used for search in the application. So, I had to create indexes on the table. However ,I experience  a slow performance when a record is inserted or updated in the table. This is most likely because of the re-calculation of indexes. </p>
  
  <p>Is there a way to improve this.</p>
  
  <p>Thanks in advance</p>