Gnarly Data Waves by Dremio cover image

EP10 - Optimizing Data Files in Apache Iceberg Performance Strategies

Gnarly Data Waves by Dremio

00:00

How to Sort a Table in Multiple Columns

When you have a query with a filter on all of this feed, right? For example, like, consider this particular query. And well, it's not like you can just sort one column in the table, right? It's not like that. You can also obviously hierarchically sort the column, right? What I mean to say is that you can sort by first by employee name, followed by employee salary, following by employee ID and so on. But how do you optimize the query when you have multiple dimensions to filter on? So that's our next question.

Play episode from 23:30
Transcript

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app