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

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 232,852 Most Valuable Professional on at

Like (1)

Report

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

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.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,017 Super User 2025 Season 1

#2

Martin Dráb 232,852 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans