From: Action Request System discussion list(ARSList) on behalf of Frank Caruso
Sent: Mon 10/25/2010 11:33 AM
To: arslist@ARSLIST.ORG
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
Sent: Monday, October 25, 2010 8:33 AM
To: arslist@ARSLIST.ORG
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
--
*From:* Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] *On Behalf Of *Frank Caruso
*Sent:* Monday, October 25, 2010 8:33 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Indexing Values Rarely Used
** Because they want to be able
.
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Monday, October 25, 2010 8:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: Indexing Values Rarely Used
** Because they want to be able
] on
behalf of Misi Mladoniczky [...@rrr.se]
Sent: Tuesday, October 26, 2010 11:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Indexing Values Rarely Used
Hi,
You may need to tune your database settings to get the index to be used.
An index where 90% of the records has the same value (NULL, Status=Closed
Why do you need an index on a column that rarely contains a value?
--
J
2010/10/22 Frank Caruso caruso.fr...@gmail.com:
** 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
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
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
-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Friday, October 22, 2010 8:28 AM
To: arslist@ARSLIST.ORG
Subject: Indexing Values Rarely Used
Oracle 10G on Solaris 10
If in an index is added to a form against a single column
9 matches
Mail list logo