Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpolation

From: Cimode <cimode_at_hotmail.com>
Date: 30 Apr 2007 06:33:56 -0700
Message-ID: <1177940035.611379.324560_at_n76g2000hsh.googlegroups.com>


On Apr 30, 2:21 pm, "David Cressey" <cresse..._at_verizon.net> wrote:
> "Cimode" <cim..._at_hotmail.com> wrote in message

> In practice, I've been willing to use NULLS in databases rather than
> decompose tables to eliminate the need for NULLS. And I've tended to avoid
> SQL 3VL, by forumlating my queries carefully.
Think about it: do you prefer to add one extra table once at design time or keep adding IS NULL/ IS NOT NULL extra resource consuming clause on ALL processes using a specific table. You simply kill both performance (additional index scan) and correctness of results (no matter how many clauses you add, you may skip one over several procedures.)

Hope this clarifies a bit. Received on Mon Apr 30 2007 - 15:33:56 CEST

Original text of this message