(You could also combine a static filter with a dynamic bloom filter in front. A bit like generational garbage collection.)
A recent paper trying to systematically apply the idea to databases "Towards Systematic Index Dynamization" ( https://bpb-us-e1.wpmucdn.com/sites.psu.edu/dist/b/123163/fi... )
(You could also combine a static filter with a dynamic bloom filter in front. A bit like generational garbage collection.)