1. MdTravler New Member

   I have a large table around 100 million rows.. I want to join a particular column varchar column in this table to another table of a few million emails to check for the existence in one table against another table. Would there be an efficiency gained by computing a checksum for the varchar column - indexing and using that to join?
   

   MdTravler, Jan 10, 2011

   #2
2. satya Moderator

   Welcome to the forums.
   How frequently you are going to execute this query?
   For SELECT query performance indexes would always help, but given the data type of the columns you may be wasting space and it may lead to table scan which may hamper the performance.
   

   satya, Jan 11, 2011

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in