Hi,

I have some cases when I set index on a field which is member of detail
table but represent connection to a master table like foreign key that
optimizer use that index for some sql statements. Does firebird work
better or faster with indexing foreignkey fields in master detail
scenario, or foreign key is index in same time?

Thanks in advanced