how to optimize this select statement as the records in earlier table is abt i million
and this simplet select statement is not executing and taking lot of time
INTO table gt_corcts
FOR all entries in gt_mege
WHERE /sapsll/corcts~stcts = gt_mege-ctsex
and /sapsll/corcts~guid_pobj = gt_Sagmeld-guid_pobj.