Jonathan Lewis Index Question

Or anyone else who knows indexes to the same level. I have tables joined to others by foreign keys. The foreign keys are used fairly often for query joins between the tables and usually refer to a single sequence-based primary key. The foreign keys have B-tree indexes. Given that the keys are used for queries, as a general rule do you suggest

a)    dropping the indexes
b)    using a compress = 1 clause on the indexes
c)    something else

Thanks,

Van Received on Sat Apr 14 2001 - 10:57:43 CDT