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 experience about 3 hours for only one filter transaction, so they heard about partitioning in sqlserver 2008 as our database so they give this task to search and test this method, so i read it and found out its good coz it help a lot for performance, but then when i test the unpartitioned table contains about 600 000 rows and a query given to me to test it, its takes about 2 minutes and 50+ seconds, so i tried now the partitioned table to expect that it will goes lower that the other one, now the query time goes to higher it takes about 3 minutes and 42 seconds for the partitioned table..i was confuse about this thing.. please advise or if you have some method to do a good retrieval performance..thanks in advance..