AX2012 List Pages - Performance Improvement

The main query performance is slow due to the fact that the query parameter OPTION(FAST) is not being added automatically to the SQL statement, as it does with most standard forms in Dynamics AX. 

 some of the list pages where this could be a problem, see the workaround notes below:

Vendor List Page

Object: Query > VendTableListPage > Data Sources > VendTable

Change the “FirstFast” property on the “VendTable” in this view to “Yes”.

Sales Table List Page

Object: Query > SalesTableListPage > Data Sources > SalesTable

Change the “FirstFast” property on the “SalesTable” in this view to “Yes”.

Released Product List Page

Object: Query > EcoResProductPerCompanyListPage > Data Sources > InventTable

Change the “FirstFast” property on the “InventTable” in this view to “Yes”.

Main Accounts List Page

Object: Query > MainAccountsListPage > Data Sources > MainAccount

Change the “FirstFast” property on the “MainAccount” in this view to “Yes”.

CustTable List Page

Object: Query > MainAccountsListPage > Data Sources > CustTable

Change the “FirstFast” property on the “CustTable” in this view to “Yes”.

Ledger Trial Balance List Page

Object: Query > LedgerTrialBalanceListPage > Data Sources > DimAttrvalueCombo

Change the “FirstFast” property on the “DimAttrvalueCombo” in this view to “Yes”.

thanks to tom treen

original post - http://blogs.msdn.com/b/axsupport/archive/2012/10/10/ax2012-list-pages-performance-improvement.aspx