Re: (domain support) Re: theory and practice: ying and yang
From: Alfredo Novoa <alfredo_novoa_at_hotmail.com>
Date: Wed, 01 Jun 2005 16:05:04 +0200
Message-ID: <14gr91dui74i4pa5nemsh0v36571trv40q_at_4ax.com>
Date: Wed, 01 Jun 2005 16:05:04 +0200
Message-ID: <14gr91dui74i4pa5nemsh0v36571trv40q_at_4ax.com>
On Tue, 31 May 2005 16:59:50 +0100, Paul <paul_at_test.com> wrote:
>Should a DBMS with an integer domain be able to optimise a query like
>this? (where i is a column of type "integer"):
>
>SELECT * FROM tbl WHERE i*i < 0
It should.
>Or would we expect it to try squaring i for each row in turn?
We should expect that with current DBMS.
Regards Received on Wed Jun 01 2005 - 16:05:04 CEST