how to optimize this select statement its a simple select....

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

SELECT guid

stcts

INTO table gt_corcts

FROM corcts

FOR all entries in gt_mege

WHERE /sapsll/corcts~stcts = gt_mege-ctsex

and /sapsll/corcts~guid_pobj = gt_Sagmeld-guid_pobj.

regards

Arora