While OLTP databases sometimes also support analytical queries, that functionality is often performed in separate OLAP (online analytical processing) databases or data warehouses.

Online analytical processing (OLAP) databases are purpose-built for handling analytical queries. Analytical queries run on online transaction-processing (OLTP) databases often take a long time to ...

There’s no denying that analytic (i.e. OLAP) and transactional (i.e. OLTP) workloads put different demands on the underlying database. They have different I/O patterns, different latency expectations, ...