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