if we run a report it is taking so much time to display the
report,what to do to increase th performance of the report
Answer Posted / vams_gk
if we run a report it is taking so much time to display the
result to be fallowed as :
1) use aggrigate tables(contains pre caliculated data)
2)pre defined conditions,LOV's
3)in a real time senario query contains a large if
statements.some times we need to wait max of 30 min to run
perticular statement...not all
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between user and versatile user?
Explain when to use local filter and when to use global filter?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
How would you format some text using css to be verdana and bold?
How to generate the report from excel sheet?
How to restrict password to a user while sending a document in .pdf format
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How to execute the plsql procedure from the report by clicking with mouse?
When we use aggregate awareness function in designer?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
how to create metric universe ?
What is thumbnail?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?