Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / DaxGeek / Sorting Options By Using ex...

Sorting Options By Using existing indexes on the tables

Hossein.K Profile Picture Hossein.K 6,648
To use an index on a select statement, use the keyword index followed by the
name of the index: 


1
2
3
4
5
6
7
CustTable custTable;
while select custTable index AccountIdx
{
   print custTable.AccountNum, " ", 
   custTable.currency;
}
pause;

The result of this search is in the order specified by the index. You can view
available indexes for a given table in the Application Object Tree (AOT).
Indexes should only be specified when the sequence of records is important and
that sequence matches the index exactly.

Best Regards,
Hossein Karimi

Comments

*This post is locked for comments