Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: (domain support) Re: theory and practice: ying and yang

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@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 - 09:05:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US