Skip to Content
0
Jan 19, 2023 at 03:38 PM

Table query performance improvement

118 Views

Hi All,

I would like to make one querry about them to improve performance. The table has 93 million records:

SELECT COUNT(*) INTO lv_erdk_count_one FROM erdk WHERE items_archived = '1'.
SELECT COUNT(*) INTO lv_erdk_count_two FROM erdk WHERE items_archived = '2'.
SELECT COUNT(*) INTO lv_erdk_count_three FROM erdk WHERE items_archived = '3'.
SELECT COUNT(*) INTO lv_erdk_count_four FROM erdk WHERE items_archived = '4'.
SELECT COUNT(*) INTO lv_erdk_count_five FROM erdk WHERE items_archived = '5'.

Is it possible to make one query?

Thank your help in advance!