Calculation Disables Index UsageJanuary 12, 2024 · 7 min readPawSQL TeamOptimize your SQL Queries by Clicks!Copyright © 2024 PawSQL Problem Let's say we have a b-tree index c_acctbal_idx defined on table tpch.customer to accelarate queries with a condition on column c_acctbal. Let's check a query as follows: select * from tpch.customer where c_acctbal + 100 = 10000.0