ABAP performance improvment

When you delete an entry from an internal table in ABAP, the system has to re-generate the index.

Ankur Bhandari

Published: 26 Jun 2003

When you delete an entry from an internal table in ABAP, the system has to re-generate the index for all entries after your delete, slowing the report if you have many records to eliminate.

It is much quicker to do an insert of the correct records into a second table than to delete entries from the first. The reason for this is because the index is only generated for the newest element.

Dig Deeper on SAP ABAP

How do the T-SQL commands TRUNCATE TABLE and DELETE differ? TRUNCATE TABLE and DELETE are T-SQL statements with similar functions, but that doesn't make them interchangeable. They operate differently and use different amounts of SQL Server resources.

Introduction to SAP ABAP internal tables In this SAP Press book chapter download, find an overview of SAP ABAP internal tables. Learn about the different ABAP table types available.

Mainframe utilities and terminology guide This guide and glossary details the IBM mainframe utilities and other mainframe technologies to further best practices in mainframe management.

Performing RFC connection checks in NetWeaver BW with SAP TREX SAP administrators can use SAP TREX to diagnose and repair broken RFC connections between SAP NetWeaver BW and the blades of the BW Accelerator.

Update SQL Server table statistics for performance kick Here's what you need to know about using auto and manual update commands and avoiding false statistics -- two of many techniques that will fine-tune SQL Server statistics and boost performance and accuracy.

SearchERP

Epicor ERP system focuses on distribution

Companies like Jergens Industrial Supply are favoring purpose-built ERP systems like Epicor Prophet 21 for distributors over ...

Digital transformation strategy: 6 steps for success

The failure rate of digital transformation is high, but a smart and detailed strategy can vastly improve the outcome of your ...

Top 7 manufacturing challenges for 2020

Growing supply chain complexity, emerging next-gen technologies and other compelling forces will continue to challenge the ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Amazon cloud database and data analytics expand

AWS expands its Redshift data warehouse capabilities including managed storage and query acceleration at the re:Invent 2019 ...

Vendors move away from open source database software licensing

While open source is a key to success for many database vendors, it can also potentially lead to a competitive threat from a ...

Oracle looks to grow multi-model database features

Decade after decade, Oracle continues to be relevant in the database market as it pivots to include an expanding list of ...

SearchAWS

Overcome these VMware Cloud on AWS migration challenges

Plan ahead for a VMware-to-AWS cloud migration with this breakdown on common challenges organizations face during the move to ...

New AWS cost management tool, instance tactics to cut cloud bills

AWS users like Lyft and Salesforce have figured out how to keep their cloud costs as low as possible, and a new cloud management ...

A complete guide to AWS re:Invent 2019

AWS re:Invent is one of the biggest cloud and IT events of the year. Use this AWS conference guide to get the latest news and ...

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Augmented intelligence features and an in-warehouse data prep tool highlight Sisense's latest update, its second since acquiring ...

Operation Fistula uses data to treat childbirth injuries

Aided by an analytics stack developed by Exasol, nonprofit Operation Fistula is working to end obstetric fistula in targeted ...

Automated tools broaden the future scope of data science

Automated data science tools may make their way into the data science process, but are unlikely to ever be able to do everything ...

SearchContentManagement

New capabilities added to Alfresco Governance Services

The updates are intended to secure electronically stored information residing across different locations in light of recent ...

Top 5 Office 365 skills for SharePoint administrators

Microsoft SharePoint administrators need to branch out in their Office 365 skill set to support products tightly integrating with...

Box cloud content management helps simplify digital work

Box currently has three main areas of focus: integration with enterprise applications, content security and collaboration. The ...

SearchHRSoftware

3 keys to employee engagement measurement

Far too many organizations and their HR departments conduct employee engagement measurement in a way that does more harm than ...

Cornell researchers call for AI transparency in automated hiring

Researchers at Cornell University want vendors to disclose how automated hiring systems are making hiring recommendations. They ...

Why reducing hiring bias isn't easy

Because people may harbor hidden biases, diversity and inclusion initiatives can be difficult to execute. Take an in-depth look ...

ABAP performance improvment

When you delete an entry from an internal table in ABAP, the system has to re-generate the index.

Dig Deeper on SAP ABAP

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

Epicor ERP system focuses on distribution

Digital transformation strategy: 6 steps for success

Top 7 manufacturing challenges for 2020

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchAWS

Overcome these VMware Cloud on AWS migration challenges

New AWS cost management tool, instance tactics to cut cloud bills

A complete guide to AWS re:Invent 2019

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Why reducing hiring bias isn't easy

Dig Deeper on SAP ABAP

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.