Archives of the TeradataForum

Message Posted: Wed, 02 Mar 2005 @ 17:03:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wednesday, March 02, 2005 11:59 -->

Hi

I would like to know if "Sel trim(count(*)) from tablename" will affect the performance of the query

Is it a good idea to use TRIM on a numeric field without casting it to character what is the disadvantage of the same

Thanks!!

	<Prev	Next>		<<First	<Prev	Next>	Last>>