web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) how to find tables wit...

Microsoft Dynamics AX (Archived)

how to find tables without indexes in ax

(0) Share

Report

Report

Posted on by dhana sekhar

50

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Malcolm Burtt 1,475 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Darren Yu on at

Like (0)

Report
Copy link

Link copied!

I think for AX2012, the recid index is always created by default.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Martin Dráb 2 Most Valuable Professional

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans