Q. What is the difference between Row Storage and Column Storage? Row Store


Q. How to do performance testing in PRD system What are pre-requisites?



Download 156.8 Kb.
View original pdf
Page7/48
Date07.04.2021
Size156.8 Kb.
1   2   3   4   5   6   7   8   9   10   ...   48
Q. How to do performance testing in PRD system What are pre-requisites?
Ans. With SAP Netweaver 7.5 SP you can do performance trace in PRD system without much overhead, in two steps st Administor the SQLM ( tcode) – start and stop the trace. 2
nd
: Data:
SQLMD ( tcode ) in the order of the potentially expensive statement.
In order to find performance trace priority list : use tcode : SWLT ( SQL Performance tuning worklist )
Q. Class to calculate runtime in ABAP on HANA?
Ans: CL_ABAP_RUNTIME
Q. How to specify client field in Native Query?
Ans: Using SELECT DISTINCT / CLIENT SPECIFIED / USING CLIENT
Q. Tcode for EPM scenario?
Ans: SEPM_DG – Data Generator
Q. What are different Code-pushdown techniques?
Ans:
1. SQL Queries _ imperative and declarative logic (use literals, arithmetic, logical expression inside the queries and using expressions like CEIL, FLOOR, ABS, TRUNC, FRAC can be part of
Open SQL statements ),
2. CDS Views. AMDP : ABAP Managed Data Procedures. Information Models and consuming those in ABAP using proxy object techniques

Download 156.8 Kb.

Share with your friends:
1   2   3   4   5   6   7   8   9   10   ...   48




The database is protected by copyright ©ininet.org 2020
send message

    Main page