i have a question about how indexes work. lets say i have a table
called transaction with fields:
transaction (primary key)
there is already an index called transactioni1 created on the following
columns (it is a foreign key):
my question is this: if i do a select on costctr and account will oracle
make use of the existing index or should i create a new index made up of
the two columns being queried on?
thanks for the help.