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, ... How to make a Query pe...

Finance | Project Operations, Human Resources, ...

Unanswered

How to make a Query performance faster as below query is taking too long time.

(0) Share

Report

Report

Posted on by Community member

9

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

You'll find a huge amount of information about query optimization on the internet.

Because you're asking in D365 F&O forum and not in a SQL Server forum, you likely want to use the query inside F&O. If so, start by changing the query to match what F&O would use, otherwise you may be optimizing a wrong thing. I mean that you forget DataAreaId and Partition fields.

When you have the query, the first thing I would look at is the query execution plan.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 660 Most Valuable Professional

#2

André Arnaud de Cal... 549 Super User 2025 Season 2

#3

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans