SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INSTR() function is taking more time

996623Mar 13 2013 — edited Mar 13 2013

im using the below query select query in my procedure.

select distinct SUPPLIER_CIRCUIT_ID from SUPPLIER_DATA
where INSTR(i.SYSTEM_CIRCUIT_ID,SUPPLIER_CIRCUIT_ID) > 0;

I am taking SYSTEM_CIRCUIT_ID in cursor.

This query is taking more time. Is that possiblt to create function based index and speed up the query?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2013

Added on Mar 13 2013

2 comments

525 views