I think you are correct (but each DBMS has its own rules)

You could try (on a NON production box of course) adding an index and then 
analyzing it.  Add some more data and analyze it again to see the difference.  
(That is one of the items I love about TOAD)

Fred


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Frank Caruso
Sent: Friday, October 22, 2010 8:28 AM
To: [email protected]
Subject: Indexing Values Rarely Used

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

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

Reply via email to