Rule of thumb to create index in oracle table is to match with the where clause condition and Vorachate may help create table to disable logging
in table level so no redo log apply to that table thus can help improve performance but with No archive support and rollback properly when transaction