Because they want to be able to search on that field with no other criteria.
Its sort of like a pointer to an end user that may or may be included in a
ticket.

Anyhow, I was just hoping that adding the index would not put any extra
strain on the database because the value would not often be included.


On Mon, Oct 25, 2010 at 10:14 AM, Jarl Grøneng <[email protected]>wrote:

> Why do you need an index on a column that rarely contains a value?
>
> --
> J
>
> 2010/10/22 Frank Caruso <[email protected]>:
> > ** Oracle 10G on Solaris 10
> >
> > If in an index is added to a form against a single column but that column
> > rarely contains a value, does it have the same impact on the database as
> a
> > column that is indexed against a required field?
> >
> > My thought is that if there is no value provided for the column then the
> > database does not perform any extra work to maintain the index.
> >
> > Thank you
> >
> > Frank
> > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Reply via email to