HI friends

I have a long query that query contains 5 tables and joins are done very correct but that query s taking lot of time where as data in tables
are not large.Now I wat to optmize that query how should I do that
Is there any tool available for optimizing the query. I am working on sql-server 7.0 version.

Plase suggest me on optimizing the query.

Thanks & Regards

pp