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?
 
Regards
KVB

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: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.