Adding indices to SQL tables or views

• Question

• 

  

  0

  Sign in to vote

  I am new to indexing so please be patient with me.

  We are using Dynamics CRM 2011.  I have a long-running SQL query with many joins which I am trying to optimize, and I understand that one good technique is to add an index to the CRM tables I am referencing, one for each field I am joining on.

  Is this correct?

  I am actually referencing the filtered views in the query.  Can I (and should I) be adding the index to the filtered view instead of the table, or am I limited to adding indices to the table?

  Any advice, explanations or links will be welcome.

  Thank you.

  Friday, August 15, 2014 7:27 PM