1 internal table / db alternatives analysis of various table lookup approaches
Post on 21-Dec-2015
214 views
TRANSCRIPT
1
Internal Table / DB Alternatives
Analysis of Various Table Lookup Approaches
2
Using SE30 Runtime Analysis
3
Lookup in STD Table of 54K rows
4
Lookup using Sorted Table of 54K Rows
5
Lookup Using Hash Table Grouped to 255 Rows
6
DB Select for Each Row Sflight
7
ST05 SQL Trace Analysis
8
Parameter Window to Select Different Periods
9
Sample Output for Program LookUP
10
Plan for Selected SQL Statement
11
Analysis of Select in Program 3 using DB Lookup
12
Execute Plan for this Select
13
Examples – Environment (Performance Examples)