dear members, kindly tell me how do i optimize below query. Code (SQL): SELECT * FROM orderentry.physician_notes n WHERE (mrno = '00100000072193' OR mrno IN (SELECT other_mrno FROM registration.other_mrnos WHERE mrno = '00100000072193')) AND note_type IN (SELECT note_type_id FROM orderentry.physician_note_type WHERE NVL (show_notes_in_physician_menu, 'N') = 'Y') AND signed_date IS NOT NULL; Actually i want to see all those patient notes that contaion in REGISTRATION.OTHER_MRNOS table.for this I used " OR" operator. it is good for small data. but for huge data query hanged the form. kindly reply me as soon as possible.