| Subject | Re: [firebird-support] Possible solution to low selectivity index and Foreing keys trouble? |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2004-10-18T16:04:43Z |
At 11:18 AM 10/18/2004, German Pablo Gentile wrote:
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.
Regards,
Ann
>Why dont just allow to select the index to be used by a RI constraint?I know a bit about FB internals, and I assure you, at the moment a foreign
>I dont know FB internals, so i ask developers if that is possible, and can
>be a temporary solution for that trouble.
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.
Regards,
Ann