web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

Views (222)
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