一个400GB的表，一个查询——需要调优思想(SQL2005)

I have a single large table which I would like to optimize. I'm using MS-SQL 2005 server. I'll try to describe how it is used and if anyone has any suggestions I would appreciate it very much.I have a single large table which I would like