Indexes in MS CRM

Indexes added with Microsoft Dynamics CRM 2011 Update Rollup 12

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.
Url taken From http://support.microsoft.com/kb/2792837
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s