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,
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
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,