how will optimiz the performance of sql in FM ?

Answer Posted / arkchowdary

Enabling the Governer settings we will increase the
Performance.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about scorecarding?

1627


how you create security to reports?

605


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1759


Define query studio?

598


Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

1575






What is Bitmap Index?

610


what is the difference between querystudio in reportnet and cognos8

1735


-----------------What is Direct and Conventional loading?

1650


What do you understand by the term 'aggregate cache'?

573


What is the advantage of using shortcuts?

644


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1604


What is the difference b/w macros and prompt?

598


what is catalog and types of catalogs in cagnos and which is better?

697


Please explain the different stages in creating a report in cognos report net?

569


Can you define cognos decision stream?

603