You are currently offline, waiting for your internet to reconnect

Indexes added with Microsoft Dynamics CRM 2011 Update Rollup 12

More information
Update Rollup 12 includes new indexes for the following entities in the Quick Find Search Optimization feature.  See complete details below on the indexes created.  These indexes will be created during the Update Rollup 12 installation and you may notice that part of the installation will take longer to complete.  The reason for this is that the indexes need to be populated and based on the size of your dataset the completion time will vary.


Out of Box entities:


AccountBase

    <index Name="ndx_emailaddress1">

CompetitorBase

    <index Name="ndx_name">

ConnectionroleBase

    <index Name="ndx_name">

ContactBase

    <index Name="ndx_lastname">

    <index Name="ndx_middlename">

    <index Name="ndx_emailaddress1">

    <index Name="ndx_parentcustomeridname">

LeadBase

    <index Name="ndx_subject">

    <index Name="ndx_firstname">

    <index Name="ndx_lastname">

    <index Name="ndx_companyname">

ProductBase

    <index Name="ndx_name">

QueueBase

    <index Name="ndx_name">

SalesLiteratureBase

    <index Name="ndx_name">

SystemUserBase

    <index Name="ndx_firstname">

    <index Name="ndx_lastname">

<index Name="ndx_internalemailaddress">




Custom entities:

For each custom entity, a new index will be created with a name of ndx_new_name, where new_name is the Primary Field of the Custom entity.

All Indexes will be created using the Create script below:

CREATE NONCLUSTERED INDEX [ndx_new_name] ON [dbo].[new_asExtensionBase]

(

      [new_name] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]

GO

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2792837 - Last Review: 01/03/2013 16:42:00 - Revision: 1.0

Microsoft Dynamics CRM 2011

  • kbmbsmigrate kbsurveynew KB2792837
Feedback
I=4050&did=1&t=">or="var m=document.createElement('meta');m.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">