Additional Resources

Oracle Documentation

Sample Schemas

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10771/toc.htm

CASE Expressions

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/expressions004.htm#sthref809

Related Articles

Sample Schemas article on OTN

http://www.oracle.com/technology/oramag/oracle/02-jul/o42schema.html

Original DECODE paper

http://oracledoug.com/decode.html

Daniel Morgan's DECODE and CASE reference

http://www.psoug.org/reference/decode_case.html

AskTom thread on deciphering execution plans

http://asktom.oracle.com/pls/ask/f?p=4950:8:10404375799506113809::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:231814117467,

Acknowledgments

I'd like to thank the following people for sparing some of their time to read through the paper, checking it for accuracy and making some very useful suggestions for improvement. As usual, the final decisions and all of the mistakes are mine and there would have been more without their assistance.

Andrew Campbell, Sun Microsystems

Colin Garside, BUPA

John Gilroy, Ask Jeeves

Jeffrey Kemp

Jari Kuhanen, Sun Microsystems

If you spot any errors or can suggest improvements, please feel free to drop me an email at dougburns@yahoo.com

Improving SQL efficiency using CASE