Current Operations query performance.

(1) Share

Report

Posted on by Ram Mnt

Hi All,

Our manufacturing users are experiencing slow performance when opening "Current operations" form in AX 2012. when I started analyzing this issue, we don't have any customizations around this including underlying tables and views, queries. so copied the query generated by AX and ran the same in SQL server management studio and observe the same issue.

When I ran the SQL query generated by AX it took ~20 seconds. The SQL query generated by AX has hinted with "OPTION(fast 10)" when I change the hint from OPTION(fast 10) to OPTION(hash join) the query ran quickly in less than 1 second. I am unable to find a similar option from AX. Can somebody please reply, is it possible to implement hash from AX if yes how to do this.

SQL screenshots of both options.

Thanks,

Ram.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Blue Wang Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Ram,

More details ,please refer https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/dev-ref/xpp-data-query

Was this reply helpful? Yes No
Ram Mnt 19 on at

Like (0)

Report
Copy link

Link copied!

Hi Wang,

Here, in this case, we are not using select statement, we are fetching data using AOT/queries object.

Thanks,

Ram.

Was this reply helpful? Yes No