[PERFORM] Table stats

2005-05-04 Thread Mike G.
Hello, I have a table collecting stats that shows 5 Index Tuples Fetched but no Index Scans. Should there not be at least one Index Scan showing in the stats? Mike ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PR

[PERFORM] Which is more efficient?

2004-12-17 Thread Mike G.
Hi, I have data that I am taking from 2 tables, pulling out specific columns and inserting into one table. Is it more efficient to do: a) insert into x select z from y; insert into x select z from a; b) insert into x select z from y union all select z from a; I have r