CODEWITHSUNDEEP
mysqlsqlaggregate-functions
M99
M99

Reputation: 1907

Mysql - Aggregate function is very slow

I have a mysql database with very large tables. I often run queries that involve aggregate functions. Queries with the aggregate functions like MIN, MAX, SUM, COUNT are running very slow. Please help me to increase the speed.

SELECT MIN(PeriodTime) FROM ResultsTable WHERE (OrderId=271)
SELECT COUNT(*) FROM ResultsTable WHERE (OrderId=271);  ==> returns 258021

Total rows in that table = 1213284, My Query matches = 258021 rows.

I appreciate any help. Thank you.

Upvotes: 0

Views: 3667

Answers (1)

Dustin Laine
Dustin Laine

Reputation: 38533

Create an index on ResultsTable that covers PeriodTime and OrderId. That will help a lot.

Upvotes: 4

Related Questions