Query　optimization　is　a　very　complex　task　for　commercial　databases　in　case　of　performance　issue　that　needs　to　be　well　known　of　entire　structure　of　database.　In　desktop　or　web　application　at　the　back　end,　query　processing　aspires　to　be　major　factor　for　finding　the　better　execution.　We　address　the　problem　of　SQL　query　optimization　merely　from　the　perspective　of　query　response　time　in　different　databases　invoked　multiple　queries　are　imparted　in　admission　database　management　system,　leveraging　join　and　complex　queries.　Our　proposed　method　adhering　with　respect　to　the　underlying　topics,　to　tune　(Select,　complex　and　join　SQL)　queries　with　optimized　execution　plan　using　PL/SQL　features　by　incorporating　database　objects　such　as　procedures,　triggers　and　methods　to　improve　query　performance,　instead　amendment　of　query　semantics　which　lessen　time　of　developer　or　administrator　to　do　manual　tuning.　2016　SERSC.