Since this will only happen when a domain is changed, as part of the
database schema change process I can include an update statement. I'd
prefer to get it out of the way, and the database is offline anyway to
do schema changes.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Wednesday, July 27, 2005 6:22 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Metadata changes (column type) and
performance

Rick Debay wrote:
\>

> Would it be valid to select all items from the modified columns in
> order to force the type conversion?

Selecting won't change the data on disk. Only an update does that. I
wouldn't worry about the CPU involved compared with the cost of updating
every record in the table unnecessarily.

>

Regards,


Ann



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links