Use indexes?

Seriously, we need more info....

What is "slow"?
What are the query plans?
What's your I/O setup?
What are you waiting on?
How about a tkprof?