Certain analytical queries must complete within a specific time limit. In particular, this applies to interactive queries and queries with results that must be available by a certain date and time, for example, at the start of business hours. If sufficient RAM is allocated for executing analytical queries, and temporary files are not created for them, the execution time is determined by the number of CPU cores reserved for executing analytical queries.

Use internal benchmark tests to estimate the required number of CPU cores. During these tests, time-sensitive analytical queries are executed to the test data, the size and structure of which mimic the real data to be used.