Scenario: A DBA is experiencing performance issues in a DB2 database due to the excessive use of triggers. What steps can be taken to optimize trigger performance without compromising functionality?

To optimize trigger performance in DB2, the DBA should review and optimize trigger logic by simplifying complex operations and minimizing resource-intensive tasks. Disabling triggers may not be a suitable long-term solution as it compromises functionality. Increasing hardware resources might alleviate performance issues temporarily but does not address the root cause. Materialized views may improve query performance but are not directly related to trigger optimization.