Swaminathan K
asked on
Need help on Index -Oracle -Challenging question
Hi Team,
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
WORKID NUMBER
BatchID NUMBER
SubID NUMBER
EmailAddr VARCHAR2(80)
FirstName VARCHAR2(80)
LastName VARCHAR2(80)
pinCode NUMBER
Senddate timestamp
I need an help on indexes which type of index would best suit this scenario.
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
WORKID NUMBER
BatchID NUMBER
SubID NUMBER
EmailAddr VARCHAR2(80)
FirstName VARCHAR2(80)
LastName VARCHAR2(80)
pinCode NUMBER
Senddate timestamp
I need an help on indexes which type of index would best suit this scenario.
Can you send your query here?
It depends on how you would run your script. Always ensure 1st column of EACH table on Where clause is INDEXED
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.