MySQL

renee12345 · September 2022

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 · September 2022

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.

renee12345 · October 2022

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 · September 2023

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

MySQL

Answers

Categories