Archives of the TeradataForum
Message Posted: Tue, 23 Jan 2001 @ 14:15:52 GMT
I have some follow up questions to your advice. I'm interested in how precise you have to be to avoid any overhead with varchars.
a) if join column datatypes are identical is it (essentially) the same cost for a join whatever that type is. I accept that comparing longer datatypes takes longer than shorter ones (linear increase?)?
b) Is there an overhead when joining varchar to char for the same (max.) length?
c) Is there an overhead when joining varchar to varchar for different max lengths?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|