All Forums Database
KVB 124 posts Joined 09/12
10 Dec 2014
Join on different datatype

Hi All,
I hgave a table of huge size say 750 GB contains trillions of records.Daily we process millions of records.There is a join on INTEGER and 36 character alpha numeric key.Could you please let me know will there be any impact on this?

Raja_KT 1246 posts Joined 07/09
11 Dec 2014

AFAIK, in all databases, there is performance issue when there is data type difference.

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.