Skip to Content
Sep 26, 2019 at 03:10 PM

ASE query where filter priority order


Dear experts,

I want to know on which priority order filters were applied in a query.

Let's say a query with 4 conditions in where clause. In which order these were processed.

Is it, first filter rows using 1st condition col1 = value1, on this result set apply 2nd filter and so on...

select column1, column2 from my_table where col1 = value1 and col2 = value2 and col3 = value 3 and col4 = value4