Alan,

> > You are right! Thank you The indexes are disabled. Actually all the
> > indexes of all tables are inactive. Since I know for sure we did not
> > alter indexes to deactivate them. Simply we did not know this feature.
> >
> > I like to know what else could cause this to happen.
> > The only thing we have done is dropping foreign key constraints to
> > speed up the delete of about 4.000.0000 records.
> >
> > With kind regards,
> >
> > Olivier Olmer
> > Oxolutions
> >
> >
> Olivier,
> You might also be even more excited to learn about the real use of
> domains...
> The idea is to define a (one) domain and use it over and over when you are
> defining fields of the same datatype. In your database you have defined an
> integer domain over and over and over and used each domain (describing the
> same datatype) to each new field of that same datatype. There's a lot of
> redundancy there.

I wouldn't say "same datatype" - but more "same meaning".

That is, I will define seperate domains for, for example:

ADDRESS varchar(80) and EMAIL varchar(80)

although they are the same datatype.

It's more of a conceptual thing. Better yet, the word "domain"
explains it :-)


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com