Sorry, based on such a general and vague set of information, I can't even begin to guess where the issues may be.
Look at the execution plan to understand how it's resolving your issues.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning