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 238,897 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

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

#2

Giorgio Bonacorsi 431

#3

Adis 280 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans