News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Disable index

Finance | Project Operations, Human Resources, ...

Suggested answer

Disable index

(0) Share

Report

Report

Posted on by Yuji

4,125

Hi,

During importing the bacpac into one Tier 2 environment, I saw there are some scripts to disable indexes. Are these the indexes are disabled by default? And also if I disable indexes from LCS, where can I check the list of disabled indexes?

Thanks,

All responses Img

All responses (3)

Answers Img

Answers (0)

Blue Wang on at

Like (0)

Report

RE: Disable index

Hi Yuji,

During DACPAC import, while it's creating the new DB and filling tables with data - there is clearly a step where it DISABLES all indexes, to speed up data load.

At the end of data import, it SHOULD RE-ENABLE indexes.
Suggested answer

Rahul Mohta 21,014 on at

Like (0)

Report

RE: Disable index

also should let the bacpac do it's all task including index maintenance

once it is done for better realibility could still run index update using batch job in D365FO
Suggested answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: Disable index

Hi Yuji,

Indexes are disabled during bacpac import to improve import performance and avoid unnecessary indexes updates. After data is imported there is a phase to enable these indexes. You can't disable indexes from LCS (only delete) and you can't get a list of disabled indexes from LCS.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans