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?






Suppose I have report which is running for about 3 minutes typically. What is the first step you tak..

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

Post New Answer




More OBIEE Interview Questions

Do you know about Initialization Blocks? Can you give me an example where you used them?

1 Answers  


Can you use outer join in BMM layer?

1 Answers  


How do i disable cache for only 2 particular tables?

1 Answers  


What is query repository tool?

1 Answers  


What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?

1 Answers  






What is the difference between Data Level Security and Object Level Security?

1 Answers  


What is object level security?

1 Answers  


Define pipeline. Did you use it in your projects?

1 Answers  


If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  


What is connection pool and how many connection pools did you have in your last project?

1 Answers  


If you want to create new logical column where will you create (in repository or dashboard) why?

1 Answers  


What is the difference between Single Logical Table Source and Multiple Logical Table Sources?

1 Answers  






Categories