Improve aggregate query in SQL

Question

User-1256377279 posted

Hi Guys,

Basically i want to improve the below SQL query performance currently it take 5 sec for 109 records, the total record in actual table is 11000.

select  DailyDate,ShortDate, SUM(DailyTotalCases), SUM(DailyTotalDeaths),SUM(DailyNewCases),SUM(DailyNewDeaths) from [vw_dash_ch]
GROUP BY DailyDate,ShortDate

Thanks for your help

shabbir

Answer 1

User303363814 posted

Do you have an index on DailyDate,ShortDate?

CREATE INDEX ForGrouping ON vw_dash_ch (DailyDate, ShortDate)

Answer 2

User288213138 posted

Hi shabbir_215,

Basically i want to improve the below SQL query performance

As PaulTheSmith's said, you can try to use the CREATE INDEX statement to create indexes in tables.

Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes, they are just used to speed up searches/queries.

CREATE INDEX index_name
ON table_name (column1, column2, ...);

more information about the use of CREATE INDEX you can refer to this link:

https://www.w3schools.com/sql/sql_create_index.asp

Best regards,

Sam

Answer 3

User-1256377279 posted

Thanks i will try it

Shabbir