Dynamic Filtering

Dynamic Filtering processes data in real-time, applying user-defined criteria to instantly refine results or optimize large-scale query operations.

Dynamic Filtering is a core data manipulation technology: it instantly adapts the displayed dataset based on user input or internal system logic. On the front end, this means a customer selecting 'Brand: Samsung' and 'Price: $500-700' sees immediate, precise results, often generating a dynamic URL with parameters like `?brand=samsung&price=high`. Behind the scenes (e.g., in a PrestoDB query engine), the system constructs a filter on-the-fly from a small data set to dramatically reduce the data read from a larger fact table, accelerating complex joins and improving overall performance by orders of magnitude.

https://rankmath.com/kb/what-is-a-dynamic-url/