<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
getTasksAssignedAsPotentialOwner is very slow, How to optimize it?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/lijiangt">silver lee</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/815455#815455">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>My database is oracle 11g, I use JBPM 5.4, There are 9654 records in TASK table, But getTasksAssignedAsPotentialOwner is very slow, every execute will cost more than 3 seconds.</p><p> Anybody has idea to optimize it? thanks.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Sql:</p><p>select task0_.id as col_0_0_, task0_.processInstanceId as col_1_0_, </p><p>names5_.text as col_2_0_, subjects3_.text as col_3_0_, </p><p>descriptio4_.text as col_4_0_, task0_.status as col_5_0_, </p><p>task0_.priority as col_6_0_, task0_.skipable as col_7_0_, </p><p>task0_.actualOwner_id as col_8_0_, task0_.createdBy_id as col_9_0_, </p><p>task0_.createdOn as col_10_0_, task0_.activationTime as col_11_0_, </p><p>task0_.expirationTime as col_12_0_, task0_.processId as col_13_0_, </p><p>task0_.processSessionId as col_14_0_ from Task task0_ </p><p>left outer join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id </p><p>left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id </p><p>left outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id </p><p>left outer join I18NText descriptio4_ on task0_.id=descriptio4_.Task_Descriptions_Id </p><p>left outer join I18NText names5_ on task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ </p><p>where task0_.archived=0 and (organizati6_.id='ff8080813962106e0139628fcd28000e' or organizati6_.id in ('chm.teamLeader', 'chm.approver', 'chm.operator')) and </p><p>(organizati6_.id in (select potentialo9_.entity_id from PeopleAssignments_PotOwners potentialo9_ </p><p>where task0_.id=potentialo9_.task_id)) and (names5_.language='en-UK' or (select count(names10_.Task_Names_Id) </p><p>from I18NText names10_ where task0_.id=names10_.Task_Names_Id)=0) and (subjects3_.language='en-UK' or </p><p>(select count(subjects11_.Task_Subjects_Id) from I18NText subjects11_ where task0_.id=subjects11_.Task_Subjects_Id)=0) </p><p>and (descriptio4_.language='en-UK' or (select count(descriptio12_.Task_Descriptions_Id) from I18NText descriptio12_ </p><p>where task0_.id=descriptio12_.Task_Descriptions_Id)=0) and (task0_.status in ('Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended')) </p><p>and (task0_.expirationTime is null) order by task0_.id desc;</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>query explain:</p><table bgcolor="#efefef" border="0" cellpadding="0" cellspacing="0" class="TreeTableWidget" style="font-family: 文泉驿微米黑;" width="100%"><tbody><tr><td style="border:0px solid black;background-color:#efefef;"><table align="center" bgcolor="#ffffff" border="0" cellpadding="1" cellspacing="0" class="TreeTableWidget" width="100%&quot;"><tbody><tr class="TableCell"><td bgcolor="#bbbbbb" style="border:0px solid black;background-color:#ffffff;background-color:#bbbbbb;" valign="top"> <span style="color: #444477;">OPERATION</span> </td><td bgcolor="#aaaaaa" style="border:0px solid black;background-color:#ffffff;background-color:#aaaaaa;" valign="top"> <span style="color: #444477;">OBJECT_NAME</span> </td><td bgcolor="#bbbbbb" style="border:0px solid black;background-color:#ffffff;background-color:#bbbbbb;" valign="top"> <span style="color: #444477;">OPTIONS</span> </td><td bgcolor="#aaaaaa" style="border:0px solid black;background-color:#ffffff;background-color:#aaaaaa;" valign="top"> <span style="color: #444477;">COST</span> </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";"><a name="0" rel="nofollow"><span> images/minus.gif </span></a><a href="images/gray.png"><span> images/gray.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SELECT STATEMENT </td></tr></tbody></table></span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%">   </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 417 </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";"><a name="1" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sortascending_ena.png"><span> images/sortascending_ena.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SORT </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"> ORDER BY </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 417 </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";"><a name="2" rel="nofollow"><span> images/minus.gif </span></a><a href="images/gray.png"><span> images/gray.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> FILTER </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%">   </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="3" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmafilter.png"><span> images/sigmafilter.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 过滤谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="4" rel="nofollow"><span> images/minus.gif </span></a><a href="images/and.png"><span> images/and.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> AND </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="5" rel="nofollow"><span> images/minus.gif </span></a><a href="images/or.png"><span> images/or.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> OR </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="6" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> NAMES5_.LANGUAGE='en-UK' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="7" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> (SELECT COUNT(NAMES10_.TASK_NAMES_ID) FROM I18NTEXT NAMES10_ WHERE NAMES10_.TASK_NAMES_ID=:B1)=0 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="8" rel="nofollow"><span> images/minus.gif </span></a><a href="images/or.png"><span> images/or.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> OR </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="9" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SUBJECTS3_.LANGUAGE='en-UK' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="10" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> (SELECT COUNT(SUBJECTS11_.TASK_SUBJECTS_ID) FROM I18NTEXT SUBJECTS11_ WHERE SUBJECTS11_.TASK_SUBJECTS_ID=:B2)=0 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="11" rel="nofollow"><span> images/minus.gif </span></a><a href="images/or.png"><span> images/or.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> OR </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="12" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> DESCRIPTIO4_.LANGUAGE='en-UK' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="13" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> (SELECT COUNT(DESCRIPTIO12_.TASK_DESCRIPTIONS_ID) FROM I18NTEXT DESCRIPTIO12_ WHERE DESCRIPTIO12_.TASK_DESCRIPTIONS_ID=:B3)=0 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="14" rel="nofollow"><span> images/minus.gif </span></a><a href="images/join.png"><span> images/join.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> HASH JOIN </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"> OUTER </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 416 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="15" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="16" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.ID=DESCRIPTIO4_.TASK_DESCRIPTIONS_ID(+) </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="17" rel="nofollow"><span> images/minus.gif </span></a><a href="images/join.png"><span> images/join.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> HASH JOIN </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"> OUTER </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 313 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="18" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="19" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.ID=SUBJECTS3_.TASK_SUBJECTS_ID(+) </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="20" rel="nofollow"><span> images/minus.gif </span></a><a href="images/join.png"><span> images/join.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> HASH JOIN </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"> OUTER </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 210 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="21" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="22" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.ID=NAMES5_.TASK_NAMES_ID(+) </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="23" rel="nofollow"><span> images/minus.gif </span></a><a href="images/join.png"><span> images/join.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> HASH JOIN </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%">   </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 107 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="24" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="25" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.ID=POTENTIALO9_.TASK_ID </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="26" rel="nofollow"><span> images/minus.gif </span></a><a href="images/join.png"><span> images/join.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> NESTED LOOPS </td></tr></tbody></table></span></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%">   </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 61 </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="27" rel="nofollow"><span> images/minus.gif </span></a><a href="images/gray.png"><span> images/gray.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INLIST ITERATOR </td></tr></tbody></table></span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%">   </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="28" rel="nofollow"><span> images/minus.gif </span></a><a href="images/index.png"><span> images/index.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INDEX </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"><span> SYS_C0021801 </span></td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"><span> UNIQUE SCAN </span></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 1 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="29" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="30" rel="nofollow"><span> images/minus.gif </span></a><a href="images/or.png"><span> images/or.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> OR </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="31" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> ORGANIZATI6_.ID='chm.approver' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="32" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> ORGANIZATI6_.ID='chm.operator' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="33" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> ORGANIZATI6_.ID='chm.teamLeader' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="34" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> ORGANIZATI6_.ID='ff8080813962106e0139628fcd28000e' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="35" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sortascending_ena.png"><span> images/sortascending_ena.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SORT </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%">   </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"> UNIQUE </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 19 </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="36" rel="nofollow"><span> images/minus.gif </span></a><a href="images/table.png"><span> images/table.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TABLE ACCESS </td></tr></tbody></table></span></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"><span> PEOPLEASSIGNMENTS_POTOWNERS </span></td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"><span> BY INDEX ROWID </span></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 19 </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="37" rel="nofollow"><span> images/minus.gif </span></a><a href="images/index.png"><span> images/index.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INDEX </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"><span> FK1EE418D2C122ED2 </span></td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"><span> RANGE SCAN </span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 3 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="38" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="39" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> ORGANIZATI6_.ID=POTENTIALO9_.ENTITY_ID </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="40" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmafilter.png"><span> images/sigmafilter.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 过滤谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="41" rel="nofollow"><span> images/minus.gif </span></a><a href="images/or.png"><span> images/or.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> OR </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="42" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> POTENTIALO9_.ENTITY_ID='chm.approver' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="43" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> POTENTIALO9_.ENTITY_ID='chm.operator' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="44" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> POTENTIALO9_.ENTITY_ID='chm.teamLeader' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="45" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> POTENTIALO9_.ENTITY_ID='ff8080813962106e0139628fcd28000e' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="46" rel="nofollow"><span> images/minus.gif </span></a><a href="images/gray.png"><span> images/gray.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INLIST ITERATOR </td></tr></tbody></table></span></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%">   </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="47" rel="nofollow"><span> images/minus.gif </span></a><a href="images/table.png"><span> images/table.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TABLE ACCESS </td></tr></tbody></table></span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> TASK </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"><span> BY INDEX ROWID </span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 46 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="48" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmafilter.png"><span> images/sigmafilter.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 过滤谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="49" rel="nofollow"><span> images/minus.gif </span></a><a href="images/and.png"><span> images/and.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> AND </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="50" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.ARCHIVED=0 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="51" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.EXPIRATIONTIME IS NULL </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="52" rel="nofollow"><span> images/minus.gif </span></a><a href="images/index.png"><span> images/index.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INDEX </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"><span> TASK_STATUS </span></td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"><span> RANGE SCAN </span></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 4 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="53" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="54" rel="nofollow"><span> images/minus.gif </span></a><a href="images/or.png"><span> images/or.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> OR </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="55" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.STATUS='Created' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="56" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.STATUS='InProgress' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="57" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.STATUS='Ready' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="58" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.STATUS='Reserved' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="59" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TASK0_.STATUS='Suspended' </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="60" rel="nofollow"><span> images/minus.gif </span></a><a href="images/table.png"><span> images/table.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TABLE ACCESS </td></tr></tbody></table></span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> I18NTEXT </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"> FULL </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 102 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="61" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmafilter.png"><span> images/sigmafilter.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 过滤谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="62" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> NAMES5_.TASK_NAMES_ID(+) IS NOT NULL </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="63" rel="nofollow"><span> images/minus.gif </span></a><a href="images/table.png"><span> images/table.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TABLE ACCESS </td></tr></tbody></table></span></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> I18NTEXT </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"> FULL </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%"> 102 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="64" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmafilter.png"><span> images/sigmafilter.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 过滤谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="65" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SUBJECTS3_.TASK_SUBJECTS_ID(+) IS NOT NULL </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><span><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="66" rel="nofollow"><span> images/minus.gif </span></a><a href="images/table.png"><span> images/table.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> TABLE ACCESS </td></tr></tbody></table></span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> I18NTEXT </td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"> FULL </td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 102 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="67" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmafilter.png"><span> images/sigmafilter.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 过滤谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="68" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> DESCRIPTIO4_.TASK_DESCRIPTIONS_ID(+) IS NOT NULL </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="69" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sortascending_ena.png"><span> images/sortascending_ena.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SORT </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"> AGGREGATE </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="70" rel="nofollow"><span> images/minus.gif </span></a><a href="images/index.png"><span> images/index.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INDEX </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"><span> FK2349686B98B62B </span></td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"><span> RANGE SCAN </span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 1 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="71" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="72" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> NAMES10_.TASK_NAMES_ID=:B1 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="73" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sortascending_ena.png"><span> images/sortascending_ena.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SORT </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"> AGGREGATE </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="74" rel="nofollow"><span> images/minus.gif </span></a><a href="images/index.png"><span> images/index.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INDEX </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"><span> FK2349686BB2FA6B18 </span></td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"><span> RANGE SCAN </span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 1 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="75" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="76" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SUBJECTS11_.TASK_SUBJECTS_ID=:B1 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="77" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sortascending_ena.png"><span> images/sortascending_ena.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> SORT </td></tr></tbody></table></td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td><td bgcolor="#ffffd2" style="border:0px solid black;background-color:#ffffff;background-color:#ffffd2;" valign="top" width="13%"> AGGREGATE </td><td bgcolor="#ffffdf" style="border:0px solid black;background-color:#ffffff;background-color:#ffffdf;" valign="top" width="13%">   </td></tr><tr><td bgcolor="#ffffff" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="78" rel="nofollow"><span> images/minus.gif </span></a><a href="images/index.png"><span> images/index.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> INDEX </td></tr></tbody></table></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"><span> FK2349686B69B21EE8 </span></td><td bgcolor="#dfd5d1" style="border:0px solid black;background-color:#ffffff;background-color:#dfd5d1;" valign="top" width="13%"><span> RANGE SCAN </span></td><td bgcolor="#dfdfdf" style="border:0px solid black;background-color:#ffffff;background-color:#dfdfdf;" valign="top" width="13%"> 1 </td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="79" rel="nofollow"><span> images/minus.gif </span></a><a href="images/sigmakeys.png"><span> images/sigmakeys.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> 访问谓词 </td></tr></tbody></table></td></tr><tr><td bgcolor="#ffffff" colspan="4" style="border:0px solid black;background-color:#ffffff;background-color:#ffffff;" valign="top" width="45%"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="border:0px solid black;" width="1%"><table cellpadding="0" cellspacing="0"><tbody><tr><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";">    </td><td style=";"><a name="80" rel="nofollow"><span> images/minus.gif </span></a><a href="images/empty.png"><span> images/empty.png </span></a></td></tr><tr></tr></tbody></table></td><td style="border:0px solid black;" width="99%"> DESCRIPTIO12_.TASK_DESCRIPTIONS_ID=:B1 </td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/815455#815455">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>