Adding indices to SQL tables or views RRS feed

  • Question

  • 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