Hi, I have some questions related to indices. 1. Is Forward index applied to all non specified columns of a table in default? 2. Are there ways to see query execution plans including index usage? I tried from explain, explain (type distributed), explain (type io) from presto but failed to find useful information from that 3. Some index files doesn’t seem to be purged after table deletion. Should I delete those myself if I have to make table with same name? (I didn’t try re-generation of the behavior) Thank you for your effort to such a nice software!

1. yes, it’s pinot’s data representation 2. it’s not exposed yet, we are working on this support, ref: https://github.com/apache/pinot/issues/6978 3. Table clean up is async, so it may take a while and it could be some leftover if table creation happens too quickly. Ref: https://github.com/apache/pinot/issues/7711

@Xiang Fu Thanks!