On Mon, Oct 11, 2010 at 12:38 AM, AI Rumman wrote:
> I need to join two tales say TAB_A and TAB_B, where TAB_A is greater than
> TAB_B in size and records.
> Which Table should I put first in join order?
If it's a regular old inner join it doesn't matter, the query planner
will figure it out. If
I need to join two tales say TAB_A and TAB_B, where TAB_A is greater than
TAB_B in size and records.
Which Table should I put first in join order?
Any idea please.
EXPLAIN
INSERT INTO public.historical_price ( security_serial_id, [7 fields of proprietary
data])
SELECT public.security_series.security_serial_id, [7 fields of data],
FROM obsolete.datadb_fix INNER JOIN (obsolete.calcdb INNER JOIN public.security_series
ON obsolete.calcdb.serial=public.security_
Andrew,
> I'm running and INSERT INTO ... SELECT query with this join (one record
> added per record in join), 4 hours down and all I have to show for it is
> 100 recycled transaction logs. ?
>
> If it ever returns, I can post the Explain output.
How about giving us the query and the regular EXPL
All three tables have the same integer key,
and it's indexed.
I parenthesized the joins to do the two
small tables first.
I'm running and INSERT INTO ... SELECT
query with this join (one record added per record in join), 4 hours down and all
I have to show for it is 100 recycled transact
