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: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

Re: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

From: Lauri Pietarinen <lauri.pietarinen_at_atbusiness.com>
Date: Mon, 03 Mar 2003 09:36:05 +0200
Message-ID: <3E6305E5.1020507@atbusiness.com>

Steve Kass wrote:

>
> and easily into the optimized result you desire.
> Why do you blame bags here when you should blame
> the programmer who believes this question to be represented
> by
> SELECT P#, PNAME
> FROM V_S_SP_P;
> ??

Listen, I am trying to make things _easier_ for my programmers and end users. I am hiding the complexity of the underlying tables. Are you saying that I should not be able to do this? You think each individual user and programmer should necessarily be always exposed to underlying complexity???

Please note that I even accepted that the user must remember to give DISTICT. Not even in that case did SQLServer know how to optimize the
query properly.

regards,
Lauri Pietarinen Received on Mon Mar 03 2003 - 01:36:05 CST

Original text of this message

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