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

 

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