MySQL

helpme12345

For this question: Join together two DataSets with MySQL using the name, year, and gender columns and include appropriate indexing.

Not sure what to index here, is there any additional resources around indexing?

The course doesn't go over it explicitly and this link doesn't either:

https://domohelp.domo.com/hc/en-us/articles/360042922994-Creating-a-SQL-DataFlow#h_37ff9919-86a9-4b5d-b90a-78362ccda2d3

GrantSmith

When indexing you typically want to look at the combinations of fields being used within your joins. This will allow the join to look up the data faster to be more performant.

helpme12345

Thanks @GrantSmith for the context!

Are there any additional resources you recommend to do this?

This would be my first time using MySQL and the link in DOMO doesn't include too much explicit information on how to do this successfully https://domohelp.domo.com/hc/en-us/articles/360042922994-Creating-a-SQL-DataFlow#h_37ff9919-86a9-4b5d-b90a-78362ccda2d3

pauljames

@GrantSmith, I'm running this MySQL dataflow and its taking forever. What am I doing wrong potentially?