Hola! everyone!
We are implementing access filters in an explore, however when we apply them the consumption of the query increases a lot, for example a query in the explore without access filters is 39 GB, while adding access filters in the explore increases to 118 GB, is this normal? Do you know what it is due to?
I would appreciate it if you know in these cases how I can improve performance.
First of all, Thanks!
It sounds like the extra column scan on whatever column the access filter is attached to is causing the discrepancy in sizes. This is likely normal just to the size of the table.
Does filtering directly on the column in question cause the same effect? i.e. outside of an access filter but just with a normal filter?
Depending on what type of field this is and whether or not it makes sense potentially partitioning the table by this column could help it scan less data.