Just to preface this I am very much a noob when it comes to dbs.
As the title states I want to create a new table based on query I do on an already existing table. At first I thought a view would be a good idea since I am not creating new data but removing redundant rows. The issue is the query takes around ~5min to do and that's way too slow, so I figured instead of creating a view why not use the query to create a new table that is populated once a day.
Would the smart move be to make a Scheduled Event that runs the query a day and generate the table that way?
I am using Mariadb with HeidiSQL as the IDE
Thank you in advance for all help