You are not providing nearly enough info to enable us to effectively help you. Post the slow query, all table definitons (including indexes) for tables involved in the query and the actual execution plan for the query.
Please read this article:
How to Post Performance Problems By Gail Shaw[/url]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato