Re: [PERFORM] Adaptive query execution

2014-05-13 Thread Tim Kane
> > > From: Claudio Freire >> I thought I would see what happens when I do this: >> >>SELECT * FROM ONLY table_a UNION SELECT * FROM table_b; >> >> >> > What's the point, in the context of this example? > > The sort-unique still has to be performed even if you didn't have data > in on

Re: [PERFORM] Adaptive query execution

2014-05-13 Thread Claudio Freire
On Tue, May 13, 2014 at 5:08 PM, Tim Kane wrote: > Hi all, > > So I was thinking about the following, after experimenting with constraint > exclusion. > > I thought I would see what happens when I do this: > > SELECT * FROM ONLY table_a UNION SELECT * FROM table_b; > > > I noticed that despite t

[PERFORM] Adaptive query execution

2014-05-13 Thread Tim Kane
Hi all, So I was thinking about the following, after experimenting with constraint exclusion. I thought I would see what happens when I do this: SELECT * FROM ONLY table_a UNION SELECT * FROM table_b; I noticed that despite table_a still having no data in it, the planner has already decided