definitely above query will provide you some hint BUT not tell you exact picture, i will suggest you to pick the long running or resource intensive queries, have a detailed look into it with the help of exec plan and then decide which tables need index modification or additions?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)