title: UTL_MATCH Performance
body: <p>I've got 2 tables 1 with millions of records and the other with 200k. I'm attempting to do a UTL match with a couple of concatenated columns but of course this process would take a significant amount of time (comparing each record millions of times). The x.code is just another requirement for the comparison of table1
  Is there any way that this could be sped up? It took 18min to compare 100 rows</p>
  
  <pre><code>select * 
  
  from table1 x
  where exists(select * 
               from largetable y 
               where x.state = y.state and 
                     utl_match.jaro_winkler_similarity(x.address || ' ' || x.city, y.address || ' ' || y.city) &gt; 95 and 
                     x.code like '%a%'
              );
  </code></pre>