AX / Dynamics 365 For Finance and Operations blog

AX / D365FO – Force a Select Query to use a specific index with Index Hint

15.8.2023

InventTrans inventTrans
inventTrans.allowIndexHint(true); //Use this to enable Index Hint

select inventTrans
index hint StatusItemIdx //Force db to use this index
where  inventTrans.StatusIssue == StatusIssue::OnOrder

16.12

How to Join Multiple Data Sources on Multiple Fields in a D365FO Form Query
24.10

SQL Azure DB – Creating a Restricted User in Azure SQL Who Owns Only Their Schema
23.10

AX / D365FO – Converting Enums to Text in SQL Views: The X++ Way
29.08

AX / D365FO – How to Call One Form from Another in Dynamics 365 Finance & Operations
11.06

AX / D365FO – Handling Time Zone Offsets and Daylight Saving in D365FO with X++
29.04

AX / D365FO – Preventing Auto-Creation of Empty Child Records in D365FO Join Forms with Chain of Command

AX / D365FO – Force a Select Query to use a specific index with Index Hint

Share this:

How to Join Multiple Data Sources on Multiple Fields in a D365FO Form Query

SQL Azure DB – Creating a Restricted User in Azure SQL Who Owns Only Their Schema

AX / D365FO – Converting Enums to Text in SQL Views: The X++ Way

AX / D365FO – How to Call One Form from Another in Dynamics 365 Finance & Operations

AX / D365FO – Handling Time Zone Offsets and Daylight Saving in D365FO with X++

AX / D365FO – Preventing Auto-Creation of Empty Child Records in D365FO Join Forms with Chain of Command

Leave a comment Cancel reply