Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Can SQL Server perform join operations on 3 tables each having a data record count of 10 Million ?

user-image
Question added by Deleted user
Date Posted: 2015/09/04
Abid Ali
by Abid Ali , System Development Manager , Khushhalibank Limited (KBL)

Yes,SQL Server can perform join operations on3 tables each having a data record count of Million.

 

It is advisable to do not use varchar data type in primary keys of these tables & columns that are used in joining of these tables so that this join operation can be smoothly executed.

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

I think it does, but not sure the limitation as such of million records, but it is going to create overhead on DB for sure and may hang on for longer.

Better advise may be split your queries appropriately and create tempdb..tables or #tables with only required data from the original tables and proceeding with the actual requirement is the best solution I can think of as the alternate. Thanks. 

More Questions Like This