Subject RE: [firebird-support] Composite Primary Keys and Indices
Author Helen Borrie
At 06:10 AM 22/07/2004 -0700, you wrote:
> >> No, it's not implicit at all.
>Sorry, thought it was clear that I meant "implicitly created."
> >> Firebird can always use the leftmost column(s) of an index as though
> >> (they) were an index in their own right.
>Cool. So would it follow that if I wanted to search on COLUMN_CHILD_ID
>that I *should* create an Index for that column?

Not if it is a foreign key - because Fb also creates an index automatically
on columns named as FKs. So you'll have the same problem if you try to
duplicate that index.
Sorry, I'm a bit too busy right now to go into detail...