Need help on Index -Oracle -Challenging question
Posted on 2016-10-04
Below is the structure of the table , It contains around 9 million records . The query takes a long time If i have to fetch a record for a condition on emailAddr or workid or batchid or subid.
Structure of Tmp_email
I need an help on indexes which type of index would best suit this scenario.