Re: Indexing Values Rarely Used

2010-10-26 Thread Chris Danaceau
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

Re: Indexing Values Rarely Used

2010-10-26 Thread Mueller, Doug
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

Re: Indexing Values Rarely Used

2010-10-26 Thread Frank Caruso
-- *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

Re: Indexing Values Rarely Used

2010-10-26 Thread Misi Mladoniczky
. 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

Re: Indexing Values Rarely Used

2010-10-26 Thread Guillaume Rheault
] 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

Re: Indexing Values Rarely Used

2010-10-25 Thread Jarl Grøneng
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

Re: Indexing Values Rarely Used

2010-10-25 Thread Frank Caruso
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

Indexing Values Rarely Used

2010-10-22 Thread Frank Caruso
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

Re: Indexing Values Rarely Used

2010-10-22 Thread Grooms, Frederick W
- 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