Subject Re: [firebird-support] Possible solution to low selectivity index and Foreing keys trouble?
Author Ann W. Harrison
At 11:18 AM 10/18/2004, German Pablo Gentile wrote:

>Why dont just allow to select the index to be used by a RI constraint?
>I dont know FB internals, so i ask developers if that is possible, and can
>be a temporary solution for that trouble.

I know a bit about FB internals, and I assure you, at the moment a foreign
key index is treated differently - especially in idx.cpp - from a normal
index. Making the change you suggest would require changing the way foreign
key constraints are enforced. Not a bad thing, but not a simple thing either.