Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Disable index

(0) ShareShare
ReportReport
Posted on by 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,

  • Blue Wang Profile Picture
    Blue Wang on at
    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.

    53102.PNG

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

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    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 Profile Picture
    Sergei Minozhenko 23,089 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans