Another index question

For tables that have indexes at one column per index (for the columns that have indexes), is there any benefit (apart from possibly storing data more efficiently) to combine the columns into one index? Could it save an I/O or two, for example?

Background - we just stopped supporting Oracle 7 so we haven't (yet) implmenented bitmap indexes, IOT's, etc.

Thanks,
dsb Received on Tue Jul 01 2003 - 14:22:18 CDT