The best way, IMHO, is to trace a session that is "slow", do a tkprof on it, and see where indexes would be most helpful.