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

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2050


How do you Parametermap variables in Quiries?

2004


how to create measures and dimensions?

807


How is possible this scenario using in type-in prompt.?

776


Can we test the report other than manual testing?

1906


What is defined as Cognos Impromptu?

833


hi friends pls forward impropmtu interview question

1903


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2186


How security is concerned with Reportnet? Explain its implementing steps.

1822


what is the role of cognos comsultant?what actually it means?pls reply

2076


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1765


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

1915


how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

1893


What are the types of security?

777


Can you define query studio?

737