this topic may help u. index your view instead of table http://technet.microsoft.com/en-us/library/cc917715.aspx you should check your situations...
Separate names with a comma.