Is there anyway to improve the performance(Reducing the CPU consumed is the main aim for now) of queries involving like in the where clause.
WHERE FIRST_NM LIKE :V_FIRST_NM||'%'
AND LAST_NM LIKE :V_LAST_NM||'%';
WHERE POSITION(V_FIRST_NM IN FIRST_NM) > 0
WHERE SUBSTRING(FIRST_NM FROM 1 FOR CHAR_LENGTH(V_FIRST_NM) = V_FIRST_NM
I have been following your Posts for long time and have really helped a lot
Question: Performance Tuning of SQLs results in reduction of Execution Time and CPU Utilization. What are different ways to quantify or measure this in terms of dollar amount/currency?