I'm trying to improve the performance of a form that relies on data in the TransactionLog table. If I create an index using t-sql, I get adequate performance
CREATE NONCLUSTERED INDEX [myIndex] ON [dbo].[TRANSACTIONLOG] (
[TYPE] ASC,
[PARTITION] ASC,
[CREATEDTRANSACTIONID] ASC
)
If I create the index in AX, I get columns in a different order (and an extra column for company), and performance is terrible.
create nonclustered index [I_482TYPETRANID] on [dbo].[TRANSACTIONLOG] (
[PARTITION] asc,
[DATAAREAID] asc,
[TYPE] asc,
[CREATEDTRANSACTIONID] asc
)
Is there any way to force AX to arrange the index's columns in a particular order?