How to parallelize SQL query

JohnB
JohnB Registered Posts: 32 ✭✭✭✭✭

I have a MySQL table of a billion rows that can be partitioned into 100,000 by a category column.

From that table I would like to run a complex query against each partition to produce another subset of rows, unaggregated.

How can I do this in DSS to run these queries in a few parallel threads at a time and then consolidate the results?

Best Answer

Setup Info
    Tags
      Help me…