DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2792837 - Last Review: January 3, 2013 - Revision: 1.0

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 (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

Applies to
  • Microsoft Dynamics CRM 2011
Keywords: 
kbmbsmigrate kbsurveynew KB2792837
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support