Performance issue using case statement

[ve01201]

I am facing a peculiar problem when I use a case statement and a filter condition on the same column. The sql structure I use is as follows

select
case col1
when '1'
then 'A'
when '2'
then 'B'
end col1
from
table
where col1 in ('1','2')

If I dont have the filter in where clause, the sql runs and output comes in seconds. But, if I include the filter condition, the query is running forever and i havent seen an output for tht till now.

Pl reply, if u know any work around for this as to how I can restructure my query.
thanks

[r035198x]

I am facing a peculiar problem when I use a case statement and a filter condition on the same column. The sql structure I use is as follows

select
case col1
when '1'
then 'A'
when '2'
then 'B'
end col1
from
table
where col1 in ('1','2')

If I dont have the filter in where clause, the sql runs and output comes in seconds. But, if I include the filter condition, the query is running forever and i havent seen an output for tht till now.

Pl reply, if u know any work around for this as to how I can restructure my query.
thanks

Why do you want to remove the in clause.