Subject RE: [IB-Architect] Foreign Key indexes
Author Phil Shrimpton
> From: Ann Harrison [mailto:harrison@...]

Hi,

Short answers....

> 1) The optimizer should be improved so that it doesn't
> use really terrible indexes, right?

Yes

> 2) Does it make sense to maintain indexes that can never
> be used?

No

> 3) Should InterBase just get out of the business of
> creating indexes on foreign keys?

Yes

> 4) If InterBase creates indexes on foreign keys, should
> it allow them to be dropped?

Yes

Cheers

Phil