Worked on the midnight-indexer repository to enhance database performance by implementing a composite index on the transactions table, specifically targeting the variant and id columns. This optimization was designed to accelerate queries that filter by variant and transaction id, directly improving the speed and throughput of wallet-indexer analytics. The approach included introducing a dedicated migration to manage index creation, which streamlined deployment processes and eliminated the need for ad-hoc changelog updates. All changes were linked to a specific commit for traceability. The work primarily utilized SQL and focused on database optimization techniques to deliver measurable improvements in query latency.