This may help...
http://msdn.microsoft.com/en-us/library/gg328350.aspx
- For Microsoft Dynamics CRM 2011 on-premises deployments, adding indexes is supported per the guidelines in the “Microsoft Dynamics CRM 2011 Implementation Guide."
Link to the Implementation Guide- http://www.microsoft.com/download/en/details.aspx?id=3621