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"

