Subject | RE: [IB-Architect] Foreign Key indexes |
---|---|
Author | Phil Shrimpton |
Post date | 2000-04-04T19:14:52Z |
> From: Ann Harrison [mailto:harrison@...]Hi,
Short answers....
> 1) The optimizer should be improved so that it doesn'tYes
> use really terrible indexes, right?
> 2) Does it make sense to maintain indexes that can neverNo
> be used?
> 3) Should InterBase just get out of the business ofYes
> creating indexes on foreign keys?
> 4) If InterBase creates indexes on foreign keys, shouldYes
> it allow them to be dropped?
Cheers
Phil