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