how will optimiz the performance of sql in FM ?

Answers were Sorted based on User's Feedback



how will optimiz the performance of sql in FM ?..

Answer / 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

how will optimiz the performance of sql in FM ?..

Answer / arkchowdary

Enabling the Governer settings we will increase the
Performance.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Cognos Interview Questions

What is an olap designer?

0 Answers  


i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  


how you create security to cubes ?????

4 Answers   iFlex, iGate,


How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 Answers  


how to do page breaks in cognos 8 Report studio pls give the navigation

4 Answers  






----------0Diff b/w Report Functions and Database functions?

1 Answers   IBM,


What is the abrevation of .PPR? (Power play report) or anything new?

1 Answers  


give me scenario on cascading prompts&master-detail relation

4 Answers   IBM,


What is slowely changing dimensions?why we are used SCD?

2 Answers  


wt is the differnce between Block & conditional block ?

2 Answers  


how to test reports in cognos?

0 Answers   IBM,


what is the diffence between render variable & style variable with egs? Plz reply ASAP

4 Answers   TCS,


Categories