sql - Which access method is appropriate for a table with two or more B-Tree Indexes -

sql - Which access method is appropriate for a table with two or more B-Tree Indexes -

consider client table below shown below. table contains 750 000 rows , unique b-tree index has been automatically created on primary key. in addition, suppose dba has created b-tree index on other_names + surname.

customer table

'#'customer_id

*surname

*other_names

*username

*address

.

.

.

question

a user executes query of form: select ... customer

where (surname = 'smith');

-identify of physical info access methods of oracle11g able utilize in situation.

-identify of these access methods oracle11g use; ,

-explain why access method more used compared other available access methods.

thank help!

sql oracle oracle11g