The INSRT () function of the fuzzy query in Oracle can save more than one more

Yesterday in the processing of a character split function, using the INSRT () function, the accidental discovery actually can replace the fuzzy query like, after several tests can save efficiency more than one times.

The code is as follows:

 select  distinct  (a.deptname) from  sys_depart A, gzdb_task b where  InStr ( A.deptname,b.acceptor) >    0  ;  select  distinct  (a.deptname) from  sys_depart A, gzdb_task b where  a.deptname Span style= "COLOR: #808080" >like   " %   " | |  b.acceptor| |   " %  ; 

There is a very large difference in the time it takes to return the results (multiple trials):

First sql:

Second sql:

The INSRT () function of the fuzzy query in Oracle can save more than one more