I have this query and I want to increase its performance by adding appropriate Indexes.
DELETE FROM MYTAB1 WHERE MYID1 IN ( SELECT MYID2 FROM MYTAB2 );
I am not familiar with the syntax for indices and the type of settings that they require. Please provide the same.
The main issue here is that
MYTAB1 has millions of records and thus the query takes a lot of time.
What indices do I need?