SAP ABAP Data Element SACCIDENTSEL (Redundant Identical Selects)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TWB-TST-P-PA (Application Component) Performance Analysis (Transaction ST05)
     ⤷ SQLTACC (Package) Accessible Performance Trace

Basic Data

Data Element	SACCIDENTSEL
Short Description	Redundant Identical Selects

Data Type

Category of Dictionary Type		Direct Type Entry
Type of Object Referenced		No Information
Domain / Name of Reference Type
Data Type	INT4	4-byte integer, integer number with sign
Length	10
Decimal Places	0
Output Length	11
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Redundancy
Medium	15	Redundancy
Long	30	Redundant Identical Selects
Heading	15	Redundancy

Documentation

Definition

Database read accesses to a table are regarded as identicalin this context if they match both in form and in the actual values of the WHERE condition. Identical executions of this type read the same data from the database more than once. This has a negative effect on program performance and can lead to inconsistencies ue to "dirty reads".

The measured size specifies the number of identical executions for a particular FORM of a SELECT statement. All executions that were processed identically at least once are taken into account, that is, the number of executions that could have been saved is shown.

Use

Dependencies

Example

If a statement that is identical in form was executed four times with the same values on the same table, you receive a value of 3 here.

History

Last changed by/on	SAP	20130604
SAP Release Created in	700