Some more info would be useful. Can you provide:
- an EXPLAIN of this query?
- the DDL for the tables/views involved
- the step level info for running this query from query log (table dbc.dbqlsteptbl or view dbc.qrylogstepsv)
- what is your expectation/desire for run-time for this query?
In your post you talk about 'primary key' joins. Do you mean 'primary key' or do you mean 'primary index'? These may not be the same columns in your tables. if not then that may be why you're getting an FTS access.