We have a set of database tables filled with sample data. We need to retrieve some information from the database, but it is currently slow. Your task is to deliver the same data as fast as possible.
When ready - provide free text description of every step of the optimization process and why you did it that way. If you do changes to the query or database structure - please include them too.