Subject Re: [ib-support] check constraint stops working after backup and restore
Author Tomas Michalik
Hi Raymond,

Raymond Kennington wrote:
> Tomas Michalik wrote:
> >
> > Raymond Kennington wrote:
> >
> > But then you have to create many foreign keys (we use this domain on
> > many places). Defining this constraint on a domain saves (actually would
> > save :-| ) work. And then there is still the problem with necessity of
> > creating indexes for foreign keys ...
> >
> The indexes are created automatically when a foreign key is specified.

Of course.

> Although the main table shouldn't need the extra index (and this is documented to be
> changed)

But still it is not.

> I've not found it to be a problem having it. Some say it slows down some queries,

That's one of two reasons why I don't like this in some circumstances.




Tomas Michalik
ProCA, s. r. o.
V Luzich 818, Praha 4
Czech Republic

e-mail: michalik@...
tel: +420 2 67283446