Re: data modeling confessions, part 1

#1

On Oct 19, 6:29*pm, Sampo Syreeni <de... (AT) iki (DOT) fi> wrote:

Quote:

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" )?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: data modeling confessions, part 1

comp.databases.theory comp.databases.theory

Re: data modeling confessions, part 1 - 10-19-2009 , 09:23 PM