Thank's for you attention Sir,
i have added the missing index as suggested by you and the execution plan but the run time for the complete query goes from 35 to...