Dynamics AX Interview Question Part 2 - scenario based

One of my friend attend a interview for an Europe client.. so i just want to share the questions he faced.

Client: Code optimization, There is one class in Ax. If the client wants to reduce the execution time of that operation. Its a custom class. so what are all your steps to optimize the class and reduce the time of execution

My Friend:

• Use trace and code pro filer to find out the process that take much time and optimize it
• Use indexes, joins and Queries in code.

Client: If there any clean ups available in AX to delete tables

My Friend : Yes, Sales and Purch parm table cleanups are available under AP/AR -> periodic

-> clean up. Then we can clear database log with the help of batch job. In  production its not advisable to enable the database log.

Client : Difference between For loop and While loop

My Friend: In for loop we can control the loop execution with the help of incremental operator.