At 03:13 PM 10/23/2000 -0400, Griffin, Patrick J. wrote:

>All excellent points and questions. Actually I just wanted to be sure I
>understood the problem correctly, there is still the important question of
>extensibility (DROP GENERATOR) to contemplate and now is a good opportunity
>to do that. How can generator values be reused efficiently?

The ability to reuse generators would (I think) require a change
to the stored format of the database (ODS) and this is not a
good time for that. ODS changes should be done in groups and
we're not yet ready to face the changes implied in, for example,
increasing the index key size or adding a foreign key page like
the index root page...

We're talking about 64 bits here, and most people obviously haven't
used more than 250 of them yet. A 'DROP GENERATOR' DDL statement is
easy enough and worthwhile. Poking around trying to save a potential
1000 bytes over a whole database is pointless.

Ann

Opinions offered are my own.... of course.