> I didn't know that - is there any performance improvement or any other
> implications?
>
> Tim
>

It certainly makes datatype management a lot easier... e.g. if you realise
after some time that all your address fields of e.g. VARCHAR(80) should be
100 long instead, then it's a simple matter of editing the domain and all
instances of that field will be changed. Rather than going to each field and
changing it. I know the curent tools make this task a lot easier anyway with
search metadata features etc.

Secondly, anything that you can do to maintain a smaller database footprint
will improve performance. Let's say you added 1 field onto the bottom of
each table you create knowing full well you don't want it or ever will need
it. Good decision?

And then there are instances when the full database schema is dragged off
the server. If you have 1000 domains instead of 1 to drag down, then this
will certainly take longer to come across the wire. The server will not act
intelligently and decide that since all these 1000 domains are the same,
give yo one instead - that's for you to do.

Alan