After resolving the small files problem with optimize, your queries are still slow. The column transactionId
, used for filtering, has high cardinality and is auto-incrementing. Which Delta optimization can you enable to effectively filter data based on this column?