"索引"的相关文档 - 文档中心

标签“索引”的相关文档，共8条

NC+产品方案-63配置全文检索的索引.docx
1.删除 NCHome 下的 index 目录，如果不存在该目录则进行下一步。3.进入 sysyconfig.bat操作界面如下图：对于每个索引，要指定正确的...
2026-02-08发布266 浏览2 页30 次下载164.1 KB
金蝶云星空-云星空重建索引SQL.txt
--云星空重建索引SQLDECLARE@sqlNVARCHAR(1000)=DBCCDBREINDEX(@TABLE_NAME)WITHNO_INFOMSGS;DECLARE@tblNVARCHAR(1000)=DECLAREtblcurCURSORFORSELECT[NAME]FROMsys.tablesWHERE[NAME]NOTLIKETMP%AND[NAME]NOTLIKEZ[_]%ORDERBY1FORREADONLYOPENtblcurFETCHNEXTFROMtblcurINTO@tblWHILE@@FETCH_STATUS=0BEGINEXECSP_EXECUTESQL@sql,N@table_nameNVARCHAR(1000),@tblPRINT表重建索引成功：+@tblFETCHNEXTFROMtblcurINTO@tblENDCLOSEtblcurDEALLOCATEtblcurPRINT全部执行完成！
2024-09-24发布259 浏览1 页25 次下载575 B
金蝶云星空-索引优化.zip
金蝶云星空-索引优化.zip
2024-09-24发布311 浏览0 页25 次下载391 B
金蝶云星空-索引优化(1).txt
SETANSI_NULLSONSETQUOTED_IDENTIFIERONDECLARE@sqlVARCHAR(max)SET@sql=SELECT@sql=@sql+dbccdbreindex([+name+]);+char(13)+char(10)FROMsys.tablesWHEREnameNOTLIKETMP%ANDNAMENOTLIKEZ[_]%EXEC(@sql)
2024-09-23发布422 浏览1 页17 次下载231 B
金蝶s-HR-单据加索引.txt
Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME=index_HR_EnrollEntryBillId)dropindexT_HR_EmpEnrollBizBillEntry.index_HR_EnrollEntryBillId;Ifnotexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME=index_HR_EnrollEntryBillId)createindexindex_HR_EnrollEntryBillIdonT_HR_EmpEnrollBizBillEntry(FBillID);Ifexists(select*fromKSQL_INDEXESwhereKSQL_INDNAME=index_HR_HireEntryBillId)dropindexT_HR_EmpHireBizBil...
2024-09-23发布229 浏览2 页24 次下载2.81 KB
金蝶K3WISE-重建索引.txt
DECLARE@DBCCStringNVARCHAR(1000)DECLARE@TableNameVARCHAR(100)DECLARECur_IndexCURSORFORSELECTNameASTblNameFROMsysobjectsWHERExType=UORDERBYTblNameFORREADONLYOPENCur_IndexFETCHNEXTFROMCur_IndexINTO@TableNameWHILE@@FETCH_STATUS=0BEGINPRINT重建表+@TableName+的索引........Start!SET@DBCCString=DBCCDBREINDEX(@TblName,)WITHNO_INFOMSGSEXECSP_EXECUTESQL@DBCCString,N@TblNameVARCHAR(100),@TableNamePRINT重建表+@TableName+的索引........END!FETCHNEXTFROMCur_IndexINTO@TableNameEND
2024-09-22发布402 浏览1 页43 次下载604 B
金蝶云星空 mysql索引优化深入.docx
创建test表（测试表）droptableifexiststest;createtabletest(idintprimarykeyauto_increment,c1varchar(10),c2varchar(10),c3varchar(10),c4varchar(10),c5varchar(10))ENGINE=INNODBdefaultCHARSET=utf8;insertintotest(c1,c2,c3,c4,c5)values(a1,a2,a3,a4,a5);insertintotest(c1,c2,c3,c4,c5)values(b1,b2,b3,b4,b5);insertintotest(c1,c2,c3,c4,c5)values(c1,c2,c3,c4,c5);insertintotest(c1,c2,c3,c4,c5)values(d1,d2,d3,d...
2024-09-08发布93 浏览6 页18 次下载640 KB
金蝶EAS Cloud oracle索引语句整理.zip
金蝶EAS Cloud oracle索引语句整理.zip
2024-09-06发布442 浏览0 页11 次下载1.17 KB