CB 6 CC index time out even if I change it to an hour

[vsr1]

GROUP BY/Aggregation is blocking operations (Needs group /aggregate all results first). That is taking time .