An online store keeps its orders in a PostgreSQL relational database. Analysts complain that the daily report on revenue for the year, broken down by date and product category, runs for more than an hour and slows down the website. Explain why a columnar analytical database such as ClickHouse is better suited for such reports, and why the orders themselves should still not be moved out of the relational database entirely.
Write your answer in the field below and click the "Check answer" button.
The AI feedback on your answer will appear here.