Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
Answer / madhu
Find the SQL query of the report in Admin->manage Session-> view log then run the SQL query on toad if it takes the same time even in TOAD then modify the query to reduce the query time. If the query runs normally in TOAD then we need to make changes in the repository.
|Is This Answer Correct ?||2 Yes||0 No|
Do you know about Initialization Blocks? Can you give me an example where you used them?
Can you use outer join in BMM layer?
How do i disable cache for only 2 particular tables?
What is query repository tool?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What is the difference between Data Level Security and Object Level Security?
What is object level security?
Define pipeline. Did you use it in your projects?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
What is connection pool and how many connection pools did you have in your last project?
If you want to create new logical column where will you create (in repository or dashboard) why?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?