You might want to define col3 as value order NUSI for improving the performance.
But, it is a good practice to keep the substring data substr(col3,10,2) and substr(col3,15,2) as separate columns in source table (ABC here). Because you will be doing this substr operation once but you will be accessing these columns multiple time like in where clause here.
For example, you might want to keep Area Code column separately from phone number columns. When you require to access area code, you can directly access this column without substring it every time.