If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Decide the Indexing on Column in FM

Started by davidcognos, 02 Jul 2010 05:45:56 AM

Previous topic - Next topic

davidcognos

Hi,

Is there any option in FM to select the Indexes for a table while importing the table into FM. I generally know they will be created only at the database level.

Apart from the Primary key, how can we confirm and decide that we have to create index on a particular column.Based on the performance of fetching data in FM should we have to decide later?

Thanks in Advance!!!!
Cognag31

blom0344

Make sure you run traces (or ask the DBA) to capture SQL executed. You can then use various tools (depending on the database) to check if additional indices are useful. However, you should stay alert and take the DBA's advise.
FM simply generates SQL from the model, it does not provide you with optimizing at the database level