| Re: [stellation-res] Indexes in SQL databases |
On Fri, 2002-09-20 at 00:15, Jonathan Gossage wrote: > Unlike the other databases supported by Stellation, MySql does not support > the implicit creation of indexes for foreign keys and references. It > requires that these indexes be explicitly specified. > > Can anyone see a reasn why these indexes cannot always be explicitly > specified? If there are reasons for not doing this there is a reasonably > simple workaround but it will make the code a bit more complicated. I don't have a SQL manual handy, and I'm up against a deadline, so I don't have time to look it up. I don't see anything in principle wrong with generating indices manually. On the other hand, this is *exactly* the kind of thing that the new database abstraction layer was intended to handle. I'd kind of like to see two different implementations, one of which generates the indices manually, and one which lets it be done automatically - just because I'd like to see a significantly different implementation. -Mark -- Mark Craig Chu-Carroll, IBM T.J. Watson Research Center *** The Stellation project: Advanced SCM for Collaboration *** http://www.eclipse.org/stellation *** Work Email: mcc@xxxxxxxxxxxxxx ------- Personal Email: markcc@xxxxxxxxxxx
Attachment:
signature.asc
Description: This is a digitally signed message part