其中
SELECT dbo.DocLinkArchive.*,
dbo.Doc_InceptArchiveDoc.OldTableNo AS DocumentCode,
dbo.Doc_InceptArchiveDoc.FileTitle AS Title,
dbo.Doc_InceptArchiveDoc.Resume AS Resume,
dbo.Doc_InceptArchiveDoc.ThemeWord AS SubjectWord,
dbo.Doc_InceptArchiveDoc.secretGrade AS secretGrade,
dbo.Doc_InceptArchiveDoc.FileSize AS FileSize,
dbo.Doc_InceptArchiveDoc.FileContent AS FileContent
FROM dbo.DocLinkArchive INNER JOIN
dbo.Doc_InceptArchiveDoc ON
dbo.DocLinkArchive.ID = dbo.Doc_InceptArchiveDoc.ID占查询成本的46%,平均查询时间在1分半左右
SELECT dbo.DocLinkArchive.*,
dbo.Doc_InceptArchiveDoc.OldTableNo AS DocumentCode,
dbo.Doc_InceptArchiveDoc.FileTitle AS Title,
dbo.Doc_InceptArchiveDoc.Resume AS Resume,
dbo.Doc_InceptArchiveDoc.ThemeWord AS SubjectWord,
dbo.Doc_InceptArchiveDoc.secretGrade AS secretGrade,
dbo.Doc_InceptArchiveDoc.FileSize AS FileSize,
dbo.Doc_InceptArchiveDoc.FileContent AS FileContent
FROM dbo.DocLinkArchive INNER JOIN
dbo.Doc_InceptArchiveDoc ON
dbo.DocLinkArchive.ID = dbo.Doc_InceptArchiveDoc.ID占查询成本的46%,平均查询时间在1分半左右
解决方案 »
- 内容页怎么调用母版页的函数
- 请教【高效】更新批量数据方案
- 页面刷新问题!
- 发送电子邮件 system.web.mail
- gridview自动生成列,能否将列设为都是模板列
- 问一个关于博客的用户参数问题
- treeview的问题
- (U^U)....对面的高手看过来,看过来,看过来,这里的问题请出招~~
- 点中一个控件怎么知道它拥有的所有事件?我现在只能双击控件生成一个事件!
- 使用(javascipt)windows.open打开新窗口的问题-----------急
- treeview的使用
- select t.*, t.rowid from user t WHERE t.name LIKE 'a%c' 有这种查询麽?
LEFT OUTER JOIN
dbo.Doc_PrmDetails b on DelFlag = 0 AND PrmID = 100 a.secretGrade = b.ID -----
查看一下条件的是否有索引
SELECT dbo.DocLinkArchive.DocumentID,
dbo.DocLinkArchive.ID,
dbo.DocLinkArchive.IsFiling,
dbo.DocLinkArchive.DocumentCode,
dbo.Doc_InceptArchiveDoc.OldTableNo AS DocumentCode,
dbo.Doc_InceptArchiveDoc.FileTitle AS Title,
dbo.Doc_InceptArchiveDoc.Resume AS Resume,
dbo.Doc_InceptArchiveDoc.ThemeWord AS SubjectWord,
--dbo.Doc_InceptArchiveDoc.secretGrade AS secretGrade,
dbo.Doc_InceptArchiveDoc.FileSize AS FileSize,
dbo.Doc_InceptArchiveDoc.FileContent AS FileContent,
dbo.Doc_PrmDetails.Doc_PrmDetails AS secretGrade from
dbo.DocLinkArchive,
dbo.Doc_InceptArchiveDo,
dbo.Doc_PrmDetails
where dbo.DocLinkArchive.ID = dbo.Doc_InceptArchiveDoc.ID
and Doc_InceptArchiveDoc.secretGrade = Doc_PrmDetails.ID
union all
SELECT dbo.DocLinkArchive.DocumentID,
dbo.DocLinkArchive.ID,
dbo.DocLinkArchive.IsFiling,
dbo.DocLinkArchive.DocumentCode,
dbo.Doc_InceptArchiveDoc.OldTableNo AS DocumentCode,
dbo.Doc_InceptArchiveDoc.FileTitle AS Title,
dbo.Doc_InceptArchiveDoc.Resume AS Resume,
dbo.Doc_InceptArchiveDoc.ThemeWord AS SubjectWord,
--dbo.Doc_InceptArchiveDoc.secretGrade AS secretGrade,
dbo.Doc_InceptArchiveDoc.FileSize AS FileSize,
dbo.Doc_InceptArchiveDoc.FileContent AS FileContent,
null from
dbo.DocLinkArchive,
dbo.Doc_InceptArchiveDoc
where dbo.DocLinkArchive.ID = dbo.Doc_InceptArchiveDoc.ID
and not exist (select 'X' from Doc_InceptArchiveDoc where Doc_InceptArchiveDoc.secretGrade = Doc_PrmDetails.ID)