I described the performance implications in this blog post: http://www.chesnok.com/daily/2013/08/05/why-use-over-instead-of-a-cross-join/