|Subject||RE: [IB-Architect] Foreign Key indexes|
|Author||Claudio Valderrama C.|
> -----Original Message-----Seems more and more people go in that direction... it's very likely I will
> From: David Schnepper
> Sent: Martes 4 de Abril de 2000 16:23
> My gut reaction:
> - Do not automatically create indices for FK's.
lose my auto-generated indexes. ;-)
> - SysAdmin should be allowed to disable / delete any index (evenYes, I want sysdba more as UNIX's root than as NT's administrator, namely,
> those used
> for PK / FK relationships)
more power to sysdba.
> - Ditto for triggers (even system triggers - yes, RDB$TRIGGER4I admire your enthusiasm. Paraphrasing you: where do you draw the line
> should allow
between flexibility and risk of ignoring/bypassing all the consistency
For some "special tasks", maybe they could be reduced to extensions to
standard syntax or to commands in QLI... it seems better to have the engine
do a bunch of dangerous steps. For example, currently you cannot drop a
procedure that's referenced by another and there seems to be problems
altering it, too. One approach is to be able to do such things directly =>
ignoring the dependency. Other approach is to build some functionality so
all necessary steps are taken and you don't have much chance to let the db
in an inconsistent state if you forget one step. Not sure I made my thought
On other side of the indexes' story, I remember that while kinobi was in
closed beta testing, I requested the detection of duplicated indexes, so if
you happen to define an index whose characteristics are exactly the same
than those of a previously defined (either implicit or explicit) index, then
proposed answers can be:
- Give an error message.
- Fail silently => your index already exists. No more work needed.
- If the new CREATE INDEX command is creating the index in an ACTIVE state,
activate the existing index. Deactivate it if the new CREATE INDEX command
is creating an INACTIVE index.
Just my 1E-15 cents.