which is fastest to use: like, instr or substr
295580Dec 14 2007 — edited Feb 4 2008I was curious about which one gives the fastest return on a query: like, substr or instr?
suppose I have a simple query: "select id from mytable where some_field like ¶meter || '%'"
is this much faster or slower than using "where substr(some_field,1,nvl(length(some_field,0))=¶meter"
and how about comparing like and instr?
Thanks in advance