500000 records is not a big table.
1) What is your configuration.
2) Please post the query and its execution plan to see if any indexes can help
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]