Re: data modeling confessions, part 1
From: Tegiri Nenashi <tegirinenashi_at_gmail.com>
Date: Mon, 19 Oct 2009 19:23:26 -0700 (PDT)
Message-ID: <9ca6f262-fb49-4699-9a93-e759a34f9669_at_w37g2000prg.googlegroups.com>
Date: Mon, 19 Oct 2009 19:23:26 -0700 (PDT)
Message-ID: <9ca6f262-fb49-4699-9a93-e759a34f9669_at_w37g2000prg.googlegroups.com>
On Oct 19, 6:29 pm, Sampo Syreeni <de..._at_iki.fi> wrote:
> As Oracle at least doesn't index nulls, your carefully tuned table
> refuses to perform with the most common online query, which is to ask
> for the current status of a single entity that is currently
> valid...having a null end time. Try as you might, indexing only makes
> things worse since you want to index a null, and the DBMS just won't
> comply.
Did you try FBI (on pseudocolumn such as "case when x=null then 'N/A' else x end" )? Received on Tue Oct 20 2009 - 04:23:26 CEST