Problems filtering using *

poloba

I have a big problem.
My database is over 40GB and I have a table of 10GB. The users filter in that table and is all ok, the problem is when the user filter usin *. This filter kill the server over 5-7 minutes and nobody can work with Navision.
¿Can I do anything?

Kowa

Create a key for the field to be filtered (this will increase the size of the table somewhat) and tell that users to select that key before filtering.

poloba

The field is key.
When the user filter without * the search is instant. If they uses an * then is the problem.

Kowa

Are you using the native or the SQL server ?

If the field is the first ( or only ) field in the key (it not just part of a key at 2nd,3rd etc. position) there not much else to speed it up. Optimising the table may improve it a little, but this has to be done regulary (weekly) and can take some time if the table has many keys.