From: Claudio Valderrama C. <cvalde@us...> - 2001-07-01 00:05:05
We all know that indexes whose names are automatically generated may change
their name after a backup restore. I know what Jim thinks about sql
execution plans, but well, fixing the optimizer won't happen this week.
People need plans in some circumstances.
I've been thinking this idea: when a constraint is left unnamed, it gets an
internally generated name and the index name is generated, too. Even if you
name the constraint, the index name is not under user control. What if we
twist the behavior a bit: if a constraint is given an explicit name, use
that name for the index, too. Is it dangerous?
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://www.cvalde.com - http://firebird.sf.net