Trigger to convert null->' ' - performance hit?
From: SFidai <sfidai_at_aol.com>
Date: 9 Jun 1994 12:18:01 -0400
Message-ID: <2t7fbp$c4g_at_search01.news.aol.com>
Date: 9 Jun 1994 12:18:01 -0400
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)
Fidai Received on Thu Jun 09 1994 - 18:18:01 CEST