I’m running multiple queries in parallel in columnstore, which results in slow performance.
I’m running a query on a table with 7.5 crore rows, and the query is running in 800ms.
while I’m trying to run the query twice parallel, each query taking around 1600ms.
why this is happening? and what is the optimal number of such queries we can run in a span of 1 hour?