Randell D. wrote:
Thus - Since all five columns in my table can be used individually for
specific searches, would I be better off not having keys - Since the
keys/indexes would not have to be updated, I stand a performance
improvement in this situation,true?
It's often the case that an application reads the data more than it
updates data. So the cost of updating the keys will likely give you
performance benefit on read operations many times. And depending on the
size of your dataset, the difference between an indexed search and a
non-indexed search can be huge. If the keys are actually going to get
used, it's almost certainly a net benefit to keep them.
I recommend that indexes should be removed when they are on columns that
are *never* used in search criteria, sorting, or join conditions. Even
if a column is only used very seldom, keeping an index maintained can be
justified if it's important that those rare searches run as quickly as
possible.
Regards,
Bill K.