Does DECODE FUNCITON improves the performance of a query. How efficient is if from a CASE clause

Questions by Samuel   answers by Samuel

Showing Answers 1 - 2 of 2 Answers

samir das

  • Oct 31st, 2005
 

Yes

  Was this answer useful?  Yes

Anupam Bera

  • Aug 9th, 2006
 

If you use CASE , then optimize your query by adding /*+CHOOSE*/..

This way case is faster than decode.

Also if there any case where you need to use decode under decode then that would be cumbersome and trickier. Then it's better to use CASE.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions