토드에서 돌릴땐 500msec 정도 나오는데

이클립스를 통해서 웹으로 출력할때는 속도가 엄청 느려져서 리스트가 나올 생각을 안하네요;;;

데이터는 580건이구요

쿼리는 아래와 같습니다

select b.seq, b.subject, b.writer, nvl(f.name,'no') name, b.wdate, b.code, b.chk, b.notice, bc.link
,(select count(bc.link) from board_coment bc where b.seq=bc.link) coment
    from board b ,  funttc_code f, board_coment bc --left outer join

    where b.class_code = f.CODE(+)
    and b.seq = bc.link(+)

    and substr(b.code,1,2) in('01','04')
    and substr(b.code,5,2) = '01'
    and b.chk is null
    and b.notice = 'Y'
   
union all
select b.seq, b.subject, b.writer, nvl(f.name,'no') name, b.wdate, b.code, b.chk, b.notice, bc.link
,(select count(bc.link) from board_coment bc where b.seq=bc.link) coment
    from board b ,  funttc_code f, board_coment bc --left outer join

    where b.class_code = f.CODE(+)
    and b.seq = bc.link(+)

    and substr(b.code,1,2) in('01','04')
    and substr(b.code,5,2) = '01'
    and b.chk is null
    and b.notice = 'N'

    order by notice desc, wdate desc
;

어떻게 해야 속도가 향상될까요?