I am using a select stmt to "select" one of the field (say x) of a federated link table based on match of another single field ( say y )

Its taking 15 sec for execution which is too much.
optimization possible?

Standard SQL and DB2 doesn't know anything about "fields" and "federated link tables". Do you mean "columns" and "nicknames"? If so, it would be helpful to know the exact statement you are using, some information on the schema (indexes and the like), and also the usual information about which DB2 system you are using on which platform.

I am using DB2 v 8.

What's the access plan for the statement? In there, you will also see the query that is shipped to the remote server. Are there sufficient indexes on the remote server to support that query?

How many results do you get back? Maybe there are 1 billion qualifying rows, so that it just takes time to shuffle them over the network wire...

I can run access plan . Since I am not sure with what details are required for you, I am waiting for your reply so that I can get you what information you need
Thanks

Sorry, I don't understand your question. The only thing you have to do is take your query and produce the explain output/access plan for it.

There are sufficient indexes on the table. Not sure what would be the bottleneck

Prem, check the runstats you did on the object...

... are the stats all right?

that is not indexable. Rewrite it to

Finally i got it..!!
For validation purposes,I declared the variable var1 as varchar(100) instead of database field type varchar(7). When I matched the size with the database field size, the query executes in no second..!! and this resolved my issue!
Anyways Thanks so much for helpful suggestions