Re: Indexes and Explain Plan Question
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.
Subject
Views
Written By
Posted
1441
January 17, 2014 12:18PM
1100
January 18, 2014 10:17AM
899
January 19, 2014 07:07AM
Re: Indexes and Explain Plan Question
815
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.