two tables: table_1 and table_2 both have exactly the same schema. table_1 has 2.15MM rows of data, table_2 has 3.35MM row of data. No indexing<div><br></div><div>created a new table: table_combined using same schema as table_1</div>
<div><br></div><div>insert into table_combined select * from table_1;</div><div><br></div><div>(30 minutes later)</div><div><br></div><div>insert into table_combined select * from table_2;<br></div><div><br></div><div>(40 minutes later)</div>
<div><br></div><div>select count(*) * 1 from table_combined;</div><div><br></div><div>this give ONLY 2.15MM rows with same rows as table_1</div><div><br></div><div>What happened to table_2?!?</div><div><br></div><div>Yes, I&#39;ve check dfarm size. It equals 2*(table_1 + table_2 )</div>
<div><br></div><div>So it&#39;s there but &quot;just not seeing it&quot;</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div>