Indexing

[elisha]

How to Identify  that the table is correctly Indexed on the database ? What we have to take care about proper indexing ?

[BIsrik]

I think there is no means to check that in RN. U can only check it by executing a report based on the indexed table...

Srik.

[Annette]

Look in the "model.xml" file of your FM project.Ã,  The indexes should be in there...if they aren't, make sure you have saved your model then look again.Ã,  Do a search for the word "index" and from there you can see how they are laid out.Ã, 

l always make sure all the indexes are recognized by FM before I start editing the metadata, because I found that the only way to get indexes recognized by FM is upon importing the object.Ã,  Cognos has confirmed that this is a bug.Ã,  We use Sybase, if that matters.

[cognosfreelancer]

Annette

because I found that the only way to get indexes recognized by FM is upon importing the object.Ã,  Cognos has confirmed that this is a bug.

Can you clarify the above statement, we need to import the metadate before we get to do anthing to it, so I do not follow your point

Thanks

[sir_jeroen]

If there is any index found by CRN than it can be found there..
ReportNet uses indexes in order to define the unique identifiers....

[sir_jeroen]

Elisha...
Just curious.. Why do you want to know if the table is correctly indexed? Indexes are used for defining identifiers but you can set them manually too...