+1Hi,
I was solving this issue
https://forum.vertica.com/discussion/239524/how-to-fix-corelated-subquery-with-not-in#latest
and found the answer using cross join. However, this query is taking a lot of time as the cross join is resulting in several billions of rows. I want to achieve the same result without cross join.
is there a way to achieve this?
+2Can you share the query you wrote?
+1Hi VerticaForums,
It is the same query what you have given, but I have millions of records in players table when we take cross product with thousands of records in matches it will result in billions of records. That is the problem.
How do we rewrite this query, to solve this issue
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
