web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Is there any way set p...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Is there any way set partitioning option on indexes in AOT

(0) Share

Report

Report

Posted on by pnosvw

32

Hi experts,

base on our situation we try to apply some partitions on sql based on some datetime fields

we should apply this changes on indexes

but I can't find anythings in AOT for that purpose

thanks for your help

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

You can do the change directly in SQL. However, during DB sync those changes could be deleted. To stop that in applicaion class there is DBsync method where you can add direct SQL there to recreate those changes. You will find some example there. Standard app recreates Store procedures in that method, so you can follow same logic.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 681

#2

André Arnaud de Cal... 446 Super User 2026 Season 1

#3

Syed Haris Shah 202 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans