Alex Bo. wrote:

Hi,

I wanted to ask what I should expect in terms of performance out of primary-foreign keys.

foreign keys are supported by join indices, so they are fast

Do join queries that have primary keys defined on their tables return faster?

not necessarily.

Are such joins materialized in the database? If not - is there any other way to control materialization of joins?

All results of relational algebra operations are materialized in the engine,but they are not necessarily reused. This is part of ongoing development on the recycler optimizer.

regards, Martin

Thanks.