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
-
98
Netflix UI Engineers on Twitter: "Removing client-side React.js (but keeping it on the server) resulted in a 50% performance improvement on our landing page https://t.co/vM7JhWhYKu"Don’t miss what’s happeningPeople on T...
-
59
Gandiva Build Status Efficient expression evaluation Gandiva is a toolset for compiling and evaluating expressions on arrow data. It uses LLVM for doing just-in-time compilation of the e...
-
34
“#golang 1.14 will bring massive improvement in defer performance footprint”
-
16
With FreeBSD Foundation grant, Kristof Provost harnesses new parallel techniques to uncork performance bottleneck Independent embedded systems developer Kristof Provost c...
-
58
Previously for each dataset based on x Axis, an event receiver node <rect class=' bb-event-rect'> is generated to handle user's event. But when needs to render big amount of dataset, this is the main…
-
9
Optimising The Performance Of Power Query Merges In Power BI, Part 4: Table.Join And Other Join Algorithms In the
-
12
Performance improvement on front-end generated by rustdoc We recently wrote a blog post about the performance improvement in rus...
-
11
Performance is very important; it is a major factor for the success of any web application. ASP.NET Core 3.0 includes several enhancements that scale back memory usage and improve turnout. In this blog post, I provide 10 tips to help you impr...
-
7
1Password 8 arrives on Windows with a new design and big performance improvements 1Password now has a dark mode on Windows By...
-
6
Flutter 2.8 and Dart 2.15 Focus on Performance Improvement Dec 20, 2021...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK