# Skip rocks and files: Turbocharge Trino queries with Hudi's multi-modal indexing subsystem

DevFeed: [Skip rocks and files: Turbocharge Trino queries with Hudi's multi-modal indexing subsystem](<https://devfeed.tech/articles/skip-rocks-and-files-turbocharge-trino-queries-with-hudi-s-multi-modal-indexing-subsystem-8724.md>)

Original publisher: [Read original article](<https://trino.io/blog/2023/07/07/trino-fest-2023-onehouse-recap.html>)

Author: Nadine Farah, Sagar Sumit, Cole Bowden

Published: 2023-07-07T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Low Latency](<https://devfeed.tech/topics/low-latency.md>), [Orchestration](<https://devfeed.tech/topics/orchestration.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [applications](<https://devfeed.tech/tags/applications.md>), [cost](<https://devfeed.tech/tags/cost.md>), [data](<https://devfeed.tech/tags/data.md>), [deep-dive](<https://devfeed.tech/tags/deep-dive.md>), [features](<https://devfeed.tech/tags/features.md>), [latency](<https://devfeed.tech/tags/latency.md>), [low-latency](<https://devfeed.tech/tags/low-latency.md>), [performance](<https://devfeed.tech/tags/performance.md>), [scale](<https://devfeed.tech/tags/scale.md>), [speed](<https://devfeed.tech/tags/speed.md>)

## AI overview

The article recaps a Trino Fest session on improving Trino query performance with Hudi's multi-modal indexing subsystem and metadata table. It explains how write indexing, automated table services, scalable metadata, multiple index types, and asynchronous indexing can accelerate data reads, writes, and analytics.

## Source excerpt

Optimizing data access and query performance is crucial to building low-latency applications and running analytics. Even with the modern data lakehouse designed to be as efficient and performant as possible, there are a number of bottlenecks that can slow things down and plenty of challenges to overcome. Nadine and Sagar explored this at Trino Fest, introducing us to multi-modal indexing and the metadata table in Hudi, how they work, and how leveraging them with Trino can unlock queries faster than ever before.