how will optimiz the performance of sql in FM ?

Answer Posted / chaitanya

using the governor setting, enabling the allow usage of
local cache we can increase the performance.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between data mart and data warehouse?

760


how to create measures and dimensions?

832


What is meant by Reportstudio shortcut?

1939


-------------What is Coditional Prompting?

1830


how can you get the errors in job? when loops are araised we get error?

1905


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2348


What is a Datastore in Cognos?

1048


what is the difference between querystudio in reportnet and cognos8

1945


hi friends pls forward impropmtu interview question

1918


Can you define confirmed dimension?

844


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2165


--------------Diff b/w ODS and OLAP?

2976


What is the use of powerplay web viewer in cognos?

803


what is the difference between filter and condition?

842


How to publish a package by running Java Script?

1834