Quick update, I created a covering index on table1(col1, col2, col3, col4, col5, col6), after that, the query only takes 4 seconds. Now my question is how badly will this new index affect the DML performance, btw, do I still need the old index on table1(col1, col2)?

Thanks