Subject | RE: [firebird-support] Composite Primary Keys and Indices |
---|---|
Author | Robert DiFalco |
Post date | 2004-07-22T13:10:04Z |
>> 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 thoughit
>> (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?
>> It's explained in some detail in Chapter 18 of "The Firebird Book", aabout a
>> black, red and yellow doorstopper coming to a bookstore near you in
>> week from now.Great, because I pre-ordered your book from Amazon.com about two weeks
ago and I'm eagerly awaiting its arrival.
R.