eliminating cross join

jumanjijumanji ✭
edited April 2018 in General Discussion

Hi,

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?

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Can you share the query you wrote?

  • jumanjijumanji ✭

    Hi 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...