MySQL Forums
Forum List  »  Performance

Re: Indexes and Explain Plan Question
Posted by: Jerry Garcia
Date: January 19, 2014 07:19AM

Forgot to mention, I only want records where CompanyID is in both table. There will be CompanyID's in the Company table without a corresponding record in the Contact table.

The query is actually a Create Table query per the following. There are some additional fields (around 10) in the query, but I've truncated down to just the most important. None of the other fields are candidates for Keys as they are just attribute information from the other two tables.


Create Table Contact_SegmentMstr as
Select a.Email, a.CompanyID
from Contact_Temp_Seg a, Company_Temp_Seg b
Where a.CompanyID = b.CompanyID
;

The reason i'm using temp tables is that query performance is incredibly slow when joining the source tables used to create the temp tables. I've got 23M records joined to 3M records...both have PK's, but still slow performance. thanks again.

Options: ReplyQuote


Subject
Views
Written By
Posted
1441
January 17, 2014 12:18PM
1100
January 18, 2014 10:17AM
Re: Indexes and Explain Plan Question
816
January 19, 2014 07:19AM
737
January 20, 2014 03:00PM


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.