I didn't say that shrink work only on log file ,it can work on both.

but none is advisable until necessary.

back to your question:

you can use dmvs to find missing,unused indexes

you can use profiler

create a maintenance plan for index rebuilding/reorganizing if you don't have one