Q&A for scientific skepticism
/*SELECT --+ use_hash(USERS POSTS) COUNT(*) Pocet_Uziv_SVice10Post FROM USERS u WHERE EXISTS ( SELECT OwnerUserId FROM POSTS p WHERE u.id = p.OwnerUserId GROUP BY p.OwnerUserId HAVING COUNT(distinct p.id ) > 10 ) */ SELECT --+ use_hash(USERS POSTS) p.OwnerUserId, u.DisplayName , p.CreationDate , p.Title FROM USERS u, POSTS p WHERE u.id = p.OwnerUserId ORDER BY u.DisplayName ASC, p.CreationDate DESC