Re: SQL query

Posted in 1993

Richard Ridley — Wed, 22 Sep 93 11:02:02 +0800 — source: Informix-list mailing list archive (1991-1998)

Bob Baskett writes: |netters, |can someone explain why the optimizer doesnt short circuit on the |following query: | QUERY: | ------ | select * | from book_bill_back | where 1=2 | Estimated Cost: 370832 | Estimated # of Rows Returned: 4330952 | 1) book_bill_back: SEQUENTIAL SCAN | Filters: 1 = 2 I tried this with both Online 4.1 and 5.0 with the same result - perhaps this will behave differently in Online 6.2 - the new super-optimized Online :) Cheers, Richard Ridley