It must be DB2 syntax then, its not part of the ANSI standard, and a quick
test shows Oracle, MySQL and SQL Server don't support it. This would be reason enough for me to decide not to use it. I'm afraid I can't help with your performance question, DB2 is a bit of a mystery to me. What does the documentation say?