im still new on this & havent quite understand it.
i notice that AX itself hav their own indexing for its database. I want to know how AX indexing their database & how it effect SQL Server indexing.
My Problem :
I hav develope a small web application for transactional using non Windows PC device (Barcode Scanner with preinstalled WIN Embeded OS / RaspberryPI with Raspbian OS). The Table i access created from AX but i access it directly from SQL Server on my Web App. From that table, the AX run a jobs automaticaly to read and post all the transaction to AX system. The problem is, as more transaction coming in & the data getting bigger, my Web App getting slower.
I have some of suspicion and one of them is the indexing as i access it directly to the SQL Server.
Does AX indexing use the same indexing as the SQL Server have so i dont have to worry about it. But as the table have to be create from AX so that the jobs can read it and it wont work if you create the table directly from SQL Server, i can assume that AX have different indexing.
If i make another indexing outside AX like from SQL Server Maintenance Plan, does it effect or even ruin AX indexing? and for addition, i read some others forum that say AX indexing overide SQL Server Indexing.
Is there a way for me to improve my query by creating index from SQL Server without effecting AX?
Thanks
