• Query slowness is due to serveral reasons

    poor Statistics or index or disk or network need to have run trace and identify .

    for interview questions you have get through experience not an answer from experts.

    Regards
    Durai Nagarajan