Re: [PERFORM] Trying to eliminate union and sort

Hello, you may want to try starting with some CTE that first retrieve required subsets. adding ordering within those CTE might also improve the timing of following sort/join operations. (sorry for the top posting) Something like: WITH T1 AS ( SELECT id, typeid, backup_id, mycolumn1, mycolumn

[PERFORM] Thought you'd find this interesting

Hi! I’ve just learned about the water crisis and thought you would be interested to check out this story: https://waterforward.charitywater.org/et/FWIshxIN Let me know what you think! Thanks, Marcos -- Sent via WaterForward, an initiative of charity: water WaterForward, 387 Tehama Stre

Re: [PERFORM] Trying to eliminate union and sort

On 07/12/2013 04:43 PM, Josh Berkus wrote: As for the counts on the tables: table1 3,653,472 table2 2,191,314 table325,676,589 I think it's safe to assume right now that any resulting joins are not one-to-one Hmmm? How is doing a subselect in the SELECT clause even working, then?