How can I add INDEXES to SYNONYMS

[LeonelSanchezJr]

I need to add some INDEXES to my SYNONYMS.
Is this possible?


Thanks,

Leo ;-)

 

[WFGuru]

What type of database is it? For FOCUS files, you need to do a REBUILD INDEX. For relational datbases, there is nothing to add. The database handles the indexes and WebFOCUS doesn't need to know about them.

 

[LeonelSanchezJr]

The database resides in Oracle 9I.

Thanks,

Leo ;-)

 

[focwizard]

Leo,

Indexes on relational tables are created and maintained by the relational engine. Focus generates the SQL based on the fields requested, and the engine optimizes retrieval, based on whether fields are indexed or not.