Can anybody give the list of points to increase the performance with
Navision SQL DB.
1) Do I need to click the optimize button for each table OR is there nay facility to Optimize all the tables.
2)I am already using the SQL commands like FINDSET,FINDFIRST etc.,
is there anything i need to optimize my code
3)I got one download in this forum , that will give list of unused keys in
Can I deactivate all unused keys through Navision code.