Wednesday, 7 August 2013

alternate for IN operator in PL/SQL

alternate for IN operator in PL/SQL

I have this below query my question is what is the alternate way to use IN
operator which is in WHERE clause, as this is taking lot of time to pull
the records. Actually there are 1000 records in table but i need only 64
records few of them are in where clause below. This query is effecting the
performance.
select distinct T6.name from ORD_JOB_CODE T6 WHERE T6.NAME in ('G23.08',
'G10.01', 'G10.02', 'G10.03', 'G10.04', 'G10.05', 'G10.06', 'G10.07',
'G10.08','G10.09','G8.01','G8.02','G8.03','G8.04')
Please help me in solving the performance issue.

No comments:

Post a Comment