INSTR function in where clause
577621Feb 12 2008 — edited Feb 12 2008i have the following query:
UPDATE jobs j
SET j.j_validated = 'Y',
j.j_local = :p_local_lang
WHERE INSTR ('12325059,1444V250588', j.j_jref) > 0
AND EXISTS (
SELECT 'x'
FROM j_dets js
WHERE js.commodity = :p_commodity
AND js.j_ref = j.j_ref
AND js.j_sequence = j.j_sequence)
when using instr function its going for full table scan.can any help me in sorting this out.Also is there any disadvantage in using instr function in where clause?