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