• I have aded index on child but still it takes long time and in execution plan it shows index seek.