Join on different datatype

Database
KVB
Enthusiast

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

1 REPLY
Enthusiast

Re: Join on different datatype

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