I am Beginner in Ax
Can I use Index hint In Aggregation Statement … If Yes , Is it Improve Its Performance !!!
Example :
Select Sum(Qty) From InventTrans Index hint ItemIdx
Where CustInvoiceTrans.ItemId == "MyItemId "
Where InventTrans.ItemId == “MyItemId” *
Sure, you can. Nevertheless you shouldn’t enforce index use; the query optimizer usually knows better than you which index to use (because you write declarative code and you don’t how it will be executed).
If you’re not sure whether your index is used or not, analyze the execution plan.
Thanks Martin …
If a reply answers your question, please mark it as the verified solution.