Xref: alice comp.databases.oracle.misc:54229
Path: alice!news-feed.fnsi.net!enews.sgi.com!newsfeed.mathworks.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: jbrychka@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: Proper database design for best performance?
Date: Fri, 03 Mar 2000 19:32:35 GMT
Organization: Deja.com - Before you buy.
Lines: 71
Message-ID: <89p40j$u3k$1@nnrp1.deja.com>
References: <89mg61$132$1@nnrp1.deja.com> <952035101.24230.0.pluto.d4ee154e@news.demon.nl>
X-Article-Creation-Date: Fri Mar 03 19:32:35 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
X-Http-Proxy: 1.0 is-proxanne.gwl.com:3128 (Squid/2.1.PATCH2), 1.0 x37.deja.com:80 (Squid/1.1.22) for client unknown, 143.199.125.10
X-MyDeja-Info: XMYDJUIDjbrychka

That is a great idea.  Now I need to figure out how I should set up
some type of data integrety check since I'm allowing nulls in this
column.

Thanks

In article <952035101.24230.0.pluto.d4ee154e@news.demon.nl>,
  "Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote:
> Use char(1) containing NULL for processed rows and anything for
> non-processed rows. If all is well, NULL still won't be go into the
index,
> so the index will be very small.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <jbrychka@my-deja.com> wrote in message news:89mg61$132
$1@nnrp1.deja.com...
> > I would like some ideas on the best way to set up data for fast
access.
> >
> > I have a very large table that I look up for records that have not
been
> > processed.  The query would look something like this:
> >
> > select column_a
> > from table
> > where date_column is NULL
> >
> > This type of query cannot use an index so it is very slow.  To get
> > around the index issue I was thinking of defaulting this
date_column to
> > a specific date that I would then put in my query.  Something like
this:
> >
> > select column_a
> > from table
> > where date_column = :default_date
> >
> > This way I could use an index.  The only thing I don't like about
this
> > is that I am putting this bogus date value in the column.
> >
> > Another option is to add an indicator column that would default
to "N"
> > for new records and then get updated to "Y" when processed.  The
issue
> > I have with this is that I still need the date column to know when
it
> > is processed so now I have two columns instead of just one which
causes
> > the table to use more table space.
> >
> > If anybody has any opinion on this or other alternatives, I would
like
> > to hear about it.
> >
> > Thanks,
> >
> > Jim
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.