Hi,
As you are aware, we can use BigMemory SQL (either using ANSI standard SQL or through Query API) over Terracotta caches (including distributed).
For these SQL queries, does Terracotta use disk-based indexes for Searchable caches? Or are these indexes also stored in cache (L2, if TSA is being used)?
Thank you.