I have Navision 4 in SQL Option. One Table is very very big (10GB only the table). My problem is the filters of the users. The Users make filters over fields that not are keys.
The find is very very very slow.
The problem is when the filter is aply, the server dead with this query and the others users dead too.
My question is:
¿Any have a Idea for resolve this?
¿Can I deny filters for only one table o form?