Sounds good Doug.

Thank you for the information.

On Tue, Oct 26, 2010 at 10:18 AM, Mueller, Doug <[email protected]>wrote:

> **
> Frank,
>
> The overhead is the same for the index regardless of content.  Why?
> Because NULL is a value (actually the
> lack of a value) and that has to be updated in the index too so that you
> can efficiently search for NULL values
> just like any other value.
>
> So, the cost of the index is really the same.
>
> The answer for you about whether to add it is whether it is important for
> retrieval performance.  From what
> you describe, it is.  Without it, you will get table scans in the use case
> you indicate and if it is a large
> table, that is a challenge.
>
> In general, the overhead for maintaining an index is reasonably small and
> if there is a significant use for that
> index for widespread or even narrow use patterns, it is worth creating.
>
> Doug Mueller
>
>  ------------------------------
> *From:* Action Request System discussion list(ARSList) [mailto:
> [email protected]] *On Behalf Of *Frank Caruso
> *Sent:* Monday, October 25, 2010 8:33 AM
>
> *To:* [email protected]
> *Subject:* Re: Indexing Values Rarely Used
>
> ** 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"
>>
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
> _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