title: Adding Index on every foreign key - Pros and Cons?
body: <p>We have an SQL Server 2008 R2 database that is attached to our web application. Data is added each day, but MANY reports are run against it. As such the data is being read much more often than it is being written to.</p>
  
  <p>The reports are running slow, and adding the 'suggested indexes' has helped, but I think just adding every foreign key will help the most overall.</p>
  
  <p>Are there any downside? We already run a full maintenance on a Saturday (rebuilds indexes etc). so that's not a problem. </p>
  
  <p>OR, would it be best to only add indexes for all Fkeys on all tables with OVER X Rows, where x is 1000?</p>
  
  <p>Any help appreciated!</p>
  
  <p>PS, the biggest table has only 570288 rows in, the next biggest 273255. 188 tables in all, but only 32 of them have more than 1000 rows!</p>