Answer Posted / shiva kumar
We have to doing various performances, while creating a
report. We have to use commands like FOR ALL ENTRIES,
SELECT SINGLE ...we have to use inplace of SELECT *. We can
analyse this performance by using SQL Trace(T.Code ST05)
and Performance tuning(SE30).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of db connection in sap bw data acquisition?
Explain the display properties?
Describe your experience with bw extractors
How would you change the default template?
wt is difference between user group and reference user group?
Performance monitoring and analysis tools in bw
What are the combined tests?
What are value fields?
what is meant by compounding attribute tell me the scenario?
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
When you compressed multiple requests, how would you know which had ?marker update? enabled or not?
How would you optimize the dimensions?
Does it have delta facility?
What are the proposal options available?
process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations
