SQL Performance Tips (@SQLPerfTips) on Piclur: Function based indexing combined with math can tune WHERE a=b.How? Just transform it to WHERE a-b=0 and index (a-b… <a style="text-decoration: none;" rel="nofollow" target="_blank" href="http://use-the-index-luke.com/l/sql/where-clause/obfuscation/math">use-the-index-luke.com/l/sql/where-cl…</a> / Piclur

Nov 9, 2015

Function based indexing combined with math can tune WHERE a=b. How? Just transform it to WHERE a-b=0 and index (a-b… use-the-index-luke.com/l/sql/where-cl…

Something went wrong.