[lmwnshn]

In Andy Pavlo's current seminar class 15-799 [0], everyone parsed SQL to extract which columns were being accessed in a workload's queries. This was used to build an automatic index tuning tool.

[0] https://15799.courses.cs.cmu.edu/spring2022/project1.html

[crorella]

haha, we did just that in my company, but aimed at distributed tables (like HDFS) for their partition and bucketing schemata.