Description

when do query contains multiple and conditions in where , just like select count(1) from test_tbl where cast(b as string) != '' and a = 1, we can simply move the equals conditions ahead to improve the performance, the sql can be executed as select count(1) from test_tbl where a = 1 and cast(b as string) != '', below it is the performance comparsion of the two sql