Consultor Eletrônico



Kbase P136407: Can I create extra indices on the foreign database tables that would not be pulled to Schema holder?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   23/10/2008
Status: Unverified

GOAL:

Can I create extra indices on the foreign database tables that would not be pulled to Schema holder?

GOAL:

Can I have addition index on the foreign Database but not pulled in to the schema holder?

FACT(s) (Environment):

Windows for all DataServer
UNIX for Oracle DataServer
DataServer
Progress 8.x
Progress 9.x
OpenEdge 10.x

FIX:

Yes, you can have/create additional indices on the Foreign data source which would not interfere with the schema holder. However, Progress/OpenEdge would not be able to use them, and in the case of Oracle DataServer, the index hint would not be sent to the Oracle for the indices that schema holder is missing.