销售核销记录查询慢

EAS版本：750
问题：销售核销记录查询慢，只有几千条记录，但是速度也很慢。
分析：检查T_CL_WriteOffRecord表的索引信息。
默认应该有下列索引信息：

[tr][td=181]索引名称[td=116]类型[td=245]字段
[tr][td=181]IDX_WRITEOFF_FPID[td=116]nonclustered located on PRIMARY[td=245]FParentID
[tr][td=181]IX_CL_WFC_CBB[td=116]nonclustered located on PRIMARY[td=245]FCompanyOrgUnitID, FBillDate, FBillTypeNumber
[tr][td=181]IX_CL_WFC_CUST[td=116]nonclustered located on PRIMARY[td=245]FCustomerID
[tr][td=181]IX_CL_WiOff_billid[td=116]nonclustered located on PRIMARY[td=245]FBillID, FBillEntryID
[tr][td=181]IX_CL_WRITEOFF_MATERIAL[td=116]nonclustered located on PRIMARY[td=245]FMaterialID
[tr][td=181]IX_WRITE_BEID[td=116]nonclustered located on PRIMARY[td=245]FBillEntryID, FBillID
[tr][td=181]IX_WRITE_SUCMP[td=116]nonclustered located on PRIMARY[td=245]FCompanyOrgUnitID, FBillDate
[tr][td=181]PK_WriteOffRecord[td=116]nonclustered, unique, primary key located on PRIMARY[td=245]FID
如果缺失上面的索引 用下面的语句增加对应的索引即可。
注意：数据库操作有风险，请谨慎操作。
create index IDX_WRITEOFF_FPID on T_CL_WriteOffRecord (FParentID)
create index IX_CL_WFC_CBB on T_CL_WriteOffRecord (FCompanyOrgUnitID, FBillDate, FBillTypeNumber)
create index IX_CL_WFC_CUST on T_CL_WriteOffRecord (FCustomerID)
create index IX_CL_WiOff_billid on T_CL_WriteOffRecord (FBillID, FBillEntryID)
create index IX_CL_WRITEOFF_MATERIAL on T_CL_WriteOffRecord (FMaterialID)
create index IX_WRITE_BEID on T_CL_WriteOffRecord (FBillEntryID, FBillID)
create index IX_WRITE_SUCMP on T_CL_WriteOffRecord (FCompanyOrgUnitID, FBillDate)--主键索引 oracle数据库
ALTER TABLE T_CL_WriteOffRecord ADD CONSTRAINT PK_WriteOffRecord PRIMARY KEY (FID);