I work on sql server 2014 i face issue when join two tables as inner join from table package it have 100000 rows and table package2 100000 rows so it will give result as 100000 * 100000 and it take too much time so how to handle that issue of big data are there are any way to get data quickly
create table #package ( packageId int, PartId int ) insert into #package(packageId,PartId) values (1121,2311), (1121,9911), (1121,2020), (1121,5052), (1194,4311), (1194,9812), (1194,2391), (1194,5541) create table #package2 ( packageId int, PartId int ) insert into #package2(packageId,PartId) values (1121,2377), (1121,2111), (1121,3420), (1121,5057), (1194,4388), (1194,9912), (1194,1091), (1194,6441) select p.partid as partc,p2.partid as partx from #package p inner join #package2 p2 on p.packageId=p2.packageId