DB2 8.2.6 windows 2000 platform

I have a view defined as a join of a federated table (nickname pointing a table in another database) and a local table. Both table have identical indexes.

Question.

Does DB2 use indexes on both the tables when a select is issued on the view?

Thanks

Hi,
There is no garantee that DB2 will use index. You need to check it out with SQL access path.

If index is created after nickname creation, you should recreate nickname, because at nickname creation all statistics on source table are collected and stored to local database catalog.

Hope this helps,
Grofaty

Given your scenario, I doubt indexes to be used .. Data will be shipped (likely from remote to local db) and then a join performed. Index on the remote table is a remote structure and therefore cannot be used to join with a local table.

HTH

Sathyaram

the access plan should show where the join is performed, local or remote.
there are some settings for federated db, that will push to the max, the data to the remote server and execute the join at remote server ..
see info center and federated..