Re: Slow Join Performance
Posted by:
Dereck E
Date: October 06, 2015 03:42PM
Thanks Rick. I just figured out my issue. In MSSQL my blank values were NULL however when I imported the data file into MySQL they came in as empty strings. After reviewing the data, the join was resulting in over 140 Billion entries! Once I NULL'ed the empty strings, the count executed in about 10 seconds (40K results). After doing some reading I bumped up some memory settings and now it is running closer to 2 seconds.
Thanks again.
Subject
Views
Written By
Posted
1307
October 06, 2015 08:45AM
786
October 06, 2015 02:38PM
Re: Slow Join Performance
766
October 06, 2015 03:42PM
791
November 14, 2015 10:24AM
577
November 26, 2015 02:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.