Hi @Mayank I have created a table initially its performance is good when the records are less than 1Million with around 1000 QPS, when the data increased to 15Million the query performance degraded for the same QPS and it is taking more than 3secs for query.I have kept relevant indexes on the relevant columns. What am I missing and what can be the reasons for it. Please help

Usually it means not enough resources for the workload. Check if cpu / memory is fully utilized

@Mayank Yes there is maximum utilisation of CPU and Memory

Then perhaps you neee to add more resources

It is interesting, which parameters / configuration of CPU / Memory / I/O will bring the 10k - 100k QPS , such posted on main page https://pinot.apache.org/ for the table 15M - 200M rows? "it can serve hundreds of thousands of concurrent queries per second."