index in a remote table 1

[Diogo]

Hello.

I am making one join between two tables.
If i use two local tables it uses one index, if i use a local table and another one remote(with the same data), it already does not use no one index.

Why?

DR

 

[grofaty]

Hi,

What do you mean with remote table? Is this federated table (nickaname)?

If so, then try to drop nickname and recreate it. This may help if index was created after nickname creation.

Hope this helps,
Grofaty

 

[juliane26]

you can also give 'informational indexes' on nicknames.
So when you do have an index on the remote system, DB2 will know it and might use them.



Juliane