On 1/29/19 8:49 PM, Wells Oliver wrote:
I have a primary parent table with a child table per week of the year for
each week back through 2015. There are a lot of child tables. Each week's
child table has maybe 80-110m rows.
A *partititioned* table?
When I join to the parent table on a colum
On 1/29/19 6:49 PM, Wells Oliver wrote:
I have a primary parent table with a child table per week of the year
for each week back through 2015. There are a lot of child tables. Each
week's child table has maybe 80-110m rows.
When I join to the parent table on a column, it's very slow, but when
I have a primary parent table with a child table per week of the year for
each week back through 2015. There are a lot of child tables. Each week's
child table has maybe 80-110m rows.
When I join to the parent table on a column, it's very slow, but when I
manually specify the specific week's chil
