ASE query where filter priority order

former_member1194263 — Thu, 26 Sep 2019 15:10:39 GMT

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

Re: ASE query where filter priority order

Former Member — Thu, 10 Oct 2019 03:39:54 GMT

Hi Naveen,

SQL optimizer decides which condition retrive least number of records. Accordingly, it decides the order of filters to be processed. If you want enforce the order of execution of filters then you can use sub query of use filters within brackets.

topic Re: ASE query where filter priority order in Application Development and Automation Discussions

ASE query where filter priority order

Re: ASE query where filter priority order