Sergey,

select * from ( select ... ) doesn't result in doubled work?

>There's no second query in this case. As I mentioned in my other post, the execution plan for such query in most cases would be the same as with your suggestion.