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 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"
