Originally posted by abhaysk
Then you should better read PT Guide..

Abhay.
Abhay,
I believe you're asking too much for a data analyst.
Even if she/he can somehow grasp the terminologies
used in in PT. She will still be wondering of what to
do next. So, she/he will come back here and ask question
again. And you might recomend to read another documents
like DBA books itself.

I rather agree with Mr. Hanky for at least the latter part:
Uh oh, another developer doing a DBA's job.
Gotta go clean my gun collection.

When was the last time the tables was analyzed?
Can you view the indexes and try to code accordingly?
Do you think any performance type indexes would help?
When was the last time you bought your DBA lunch?