Table query performance improvement
source link: https://answers.sap.com/questions/13801278/table-query-performance-improvement.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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!
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK