Notifications
Announcements
Hi i hav a table , if i don't create any index so how can i found which index it wil use and is there any table without indexes
*This post is locked for comments
Hi
If you don;t define an index then the database will scan the entire table every time you access that table. Always define at least one index.
If you want to find all the tables in Ax that have no indexes then you can use the following X++ code...
SQLDictionary dict; DictTable dictTable;
; while select dict where dict.fieldId == 0 // only tablenames { dictTable = new DictTable(dict.tabId); if ( dictTable.indexCnt() == 0 && ! dictTable.isView() ) { info(strfmt("Table %1 has no indexes", dictTable.name())); } }
Regards
Malcolm Burtt
HSO ES Limited
I think for AX2012, the recid index is always created by default.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
TAHER Mehdi 3
Martin Dráb 2 Most Valuable Professional
Nakul 2