cvh@LE wrote:
> @Jerry : As said, I am neither the admin nor have I the privileges to
> normalize the db. Furthermore normalizing this column would create
> more overhead than performance gain could be won.
>

Not having the authority is one thing. Claiming it will create more
overhead is another - and probably FALSE.

Very seldom have I actually SEEN a degradation of performance when
normalizing a database. And virtually never when normalizing a column
with multiple values. That almost always improves performance across
the board. And it definitely improves performance on this particular query.

It was true that normalization hurt database performance - 25 years ago.
But things have come a long ways since then, and RDBMS's typically do
better with normalized data than not.

Of course, there are always exceptions. But until you actually take
performance benchmarks with your statements and your data, you can't say
that.



--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================