thanks for the reply ...our table holds about 1M per daily transaction per table, now our client experience a slow down during filtering on records on the web application(asp.net) they...