Forum Discussion

bboy0009's avatar
bboy0009
Icon for Helper II rankHelper II
3 years ago
Solved

Choice of data type to optimize

Hi guys,   Let's admit I have some transformations that could be applied on a text column or on a number column. In this case, which type of data should I take to optimize the treatment time ? text...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    bboy0009 , the Number data type is always better for join columns. Number takes less space compare to text and work faster in case of joins

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

bboy0009 , the Number data type is always better for join columns. Number takes less space compare to text and work faster in case of joins