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.