我的工作响应速度慢

前台，左上角，点击我的工作，响应速度很慢，将近一分钟才有反应。
如何操作能够让其响应速度快一点。

您好，请问您对应的系统库是什么数据库，同时您的我的工作那里有多少数据量。您尝试观察下点击我的工作后，到我的工作的内容全部加载完，看tomcat控制台会打印出哪些sql语句。

数据库：Oracle11G,
TOMCAT：后台显示执行脚本如下：
select * from
(
    select
    row_.*, rownum rownum_ from (  SELECT * FROM (select distinct doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,pen.flowname FLOWNAME,
    doc.statelabel STATELABEL,to_char(substr(pen.summary,1,1000)) as SUBJECT,
    to_char(substr(doc.AUDITORNAMES,1,2000)) as AUDITORNAMES,to_char(substr(doc.AUDITORLIST,1,2000)) as AUDITORLIST,
    doc.APPLICATIONID,doc.DOMAINID  from  HFMIS.T_DOCUMENT  doc,
    HFMIS.T_FLOW_INTERVENTION pen,HFMIS.T_FLOWSTATERT fs,HFMIS.T_NODERT node,HFMIS.T_ACTORRT actor  
    where doc.id = pen.id and doc.id =fs.docid and fs.id =node.flowstatert_id and  node.id = actor.nodert_id
    and doc.issubdoc is null and doc.parent is null
    and doc.state is not null and doc.statelabel is not null  and actor.actorid in ('11e1-a082-47e41d46-9002-ebdb095b0d35')
    ) table_0
    WHERE table_0.DOMAINID ='11e1-8786-cd56a390-bf0b-99bcf2069e5f' ) row_
    where rownum <= 10) where rownum_ > 0

SELECT COUNT(*)  FROM
(   select distinct doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,pen.flowname FLOWNAME,
    doc.statelabel STATELABEL,to_char(substr(pen.summary,1,1000)) as SUBJECT,
    to_char(substr(doc.AUDITORNAMES,1,2000)) as AUDITORNAMES,to_char(substr(doc.AUDITORLIST,1,2000)) as AUDITORLIST,
    doc.APPLICATIONID,doc.DOMAINID  from  HFMIS.T_DOCUMENT  doc,
    HFMIS.T_FLOW_INTERVENTION pen,HFMIS.T_FLOWSTATERT fs,HFMIS.T_NODERT node,
    HFMIS.T_ACTORRT actor  where doc.id = pen.id and doc.id =fs.docid and fs.id=node.flowstatert_id
    and  node.id = actor.nodert_id and doc.issubdoc is null and
    doc.parent is null and doc.state is not null and doc.statelabel is not null  
    and actor.actorid in ('11e1-a082-47e41d46-9002-ebdb095b0d35')) table_0

您好，麻烦您找下我我给您远程具体看下。我的联系方式见左下角签名。

问题已经处理，帖子可以关闭了。

好的。感谢您的反馈。能否告知您的对应的解决方案。谢谢

通过联系，楼主自行添加了索引后，对该部分进行了优化后，问题已经解决，感谢楼主反馈