Sprinto interview question

How will you optimize the database if a database join takes longer in your database design? Make a function to flat an array.