use case instead of decode. it will help to improve the performance.
It is faster, may be in nano seconds. There is no significant performance related difference between CASE or DECODE. They are virtually same, but yes CASE is much more stronger than DECODE in other areas. But peformance, NO NO NO.
Agree with Ishan ..
I've thought in some side cases DECODE supposedly performs better -however, there appears to be no evidence supporting this claim
In fact, this evidence here proves they are "about the same":
It could just be your query needs to take that time to get the information you are asking for. *shrug*
Post a more complete sample and we can comment
("We" - meaning "other people with more knowledge about this stuff than myself" )
it's very unlikely that DECODE would make any difference either way. Most likely, your statement performance isn't very stable and the degradation you saw was just a random fluke (e.g. due to less data being available via cache at that specific moment). Alternatively, it could be due to change in the query plan, but it has little to do with DECODE -- any change in query text causes it to be re-optimized, and it could have lead to a different plan because of change in statistics or application data.