Trigger to convert null->' ' - performance hit?
From: Michael Collins <mikecollins_at_cix.compulink.co.uk>
Date: Thu, 9 Jun 1994 21:53:47 GMT
Message-ID: <Cr5Gto.36M_at_cix.compulink.co.uk>
Date: Thu, 9 Jun 1994 21:53:47 GMT
Message-ID: <Cr5Gto.36M_at_cix.compulink.co.uk>
In reply to ..
> Trigger to convert null->' ' - performance hit?
>
> Message-ID: <2t7fbp$c4g_at_search01.news.aol.com>
>
> If I write a trigger for each table that contain VARCHAR2(n) columns,
> to convert '' or null values before insert/update to ' ' resulting in
> spaces. Say we have 400 tables and around 1500 such columns. Can
> anyone estimate performance hit due presence of this triggers? (very
> little, little, moderate impect, high impect)
>
Why would you want to do this ?
I'm sure it will cost more than it's worth.
Yours curious of Brighton (England)
- From the amazing PC of ----------- MikeCollins_at_cix.compulink.co.uk or MMCOLL_at_ccmail.monsanto.com ( DBA, Designer, A/P, etc. etc )