|
发表于 2015-2-3 17:21:30
|
显示全部楼层
可以参考平台的sa_taskrelation上设置的联合主键,看看sa_taskrelation__1上是否正确
SA_task上的索引如下:
create index IDX_TASK_KST_STATUS_EF on SA_Task (sStatusID, sExecutorFID);
create index IDX_TASK_KST_CFID_CT on SA_Task (sCreatorFID, sKindID, sStatusID, sTypeID, sCreateTime);
create index IDX_TASK_KST_EFID_CT on SA_Task (sKindID, sStatusID, sTypeID, sExecutorFID, sCreateTime);
create index IDX_TASK_PARENT_ID on SA_Task (sID, sParentID);
create index IDX_TASK_CREATETIME on SA_Task (sCreateTime);
create index IDX_TASK_CFID on SA_Task (sCreatorFID);
create index IDX_TASK_EFID on SA_Task (sExecutorFID);
create index IDX_TASK_SFLOWID on SA_Task (sFlowID);
create index IDX_TASK_SPARENTID on SA_Task (sParentID);
create index IDX_TASK_SPTID on SA_Task (sProcessTemplateID);
create index IDX_TASK_SPTID2 on SA_Task (sProcessTemplateID2);
create index IDX_TASK_SACTIVITYINPT on SA_Task (sActivityInTemplate);
create index IDX_TASK_CPERSONID on SA_Task (sCreatorPersonID);
create index IDX_TASK_EPERSONID on SA_Task (sExecutorPersonID);
create index IDX_TASK_NAME on SA_Task (sName);
create index IDX_TASK_DATA on SA_Task (sData1); |
|