>

2007年海洋与渔业信息第1,2013年暨南大学硕士研

- 编辑:3983金沙官网 -

2007年海洋与渔业信息第1,2013年暨南大学硕士研

20131227102143214291.doc20131227102143214291.doc请见附件

001.doc002.doc003.doc004.doc005.doc006.doc007.doc008.doc009.doc010.doc0100.doc0101.doc0102.doc0103.doc0104.doc0105.doc0106.doc0107.doc011.doc012.doc013.doc014.doc015.doc016.doc017.doc018.doc019.doc020.doc021.doc022.doc023.doc024.doc025.doc026.doc027.doc028.doc029.doc030.doc031.doc032.doc033.doc034.doc035.doc036.doc037.doc038.doc039.doc040.doc041.doc042.doc043.doc044.doc045.doc046.doc047.doc048.doc049.doc050.doc051.doc052.doc053.doc054.doc055.doc056.doc057.doc058.doc059.doc060.doc061.doc062.doc063.doc064.doc065.doc066.doc067.doc068.doc069.doc070.doc071.doc072.doc073.doc074.doc075.doc076.doc077.doc078.doc079.doc080.doc081.doc082.doc083.doc084.doc085.doc086.doc087.doc088.doc089.doc090.doc091.doc092.doc093.doc094.doc095.doc096.doc097.doc098.doc099.doc

查询分页:语句1性能提升10倍多,仅仅是由于多了个topkeyword,非常不理解啊!!!!

334新闻与传播专业基础2013.doc

1.查询时间1s内,r_object_id主键

352口腔综合考试大纲2013.doc

select top 100 * from ( 
select all  doc.r_object_id "objid",doc.name,doc.number, doc.cuid, doc.r_creation_date, doc.security, doc.bordline, doc.twicedline, doc.dline, doc.keynum, doc.creator_name, 
doc.security_name, doc.dline_name, doc.pid, doc.modifier_name, doc.tblcount, doc.r_modify_date, doc.prjdefid, doc.voldefid, doc.tabledefid,  doc.relation_id, 
doc.r_object_type "r_object_type", doc.bcode "bcode", doc.copycount, doc.securityapply, doc.pgholtime, doc.done, doc.disciplineid, doc.disciplineid_name, 
tabdef.fieldp2830b1886150468j, tabdef.fieldb7727l1886150454q, tabdef.fields5243t504621622q, tabdef.fieldt3385x504621623d, tabdef.fieldf3763y504621609s, tabdef.fieldk1536t504621614n, 
tabdef.fieldr1297k504621621z, tabdef.fieldb5089j1350775945q, tabdef.fieldk5874q1350775954t, tabdef.fieldb2206h1350775945a, tabdef.fieldf4308a1350775949v, tabdef.recid, 
CAST(ROW_NUMBER() OVER(ORDER BY doc.r_object_id asc ) as int) as dm_rnum 
from ps_fld_doctree_document_sp  doc 
LEFT OUTER JOIN tabledef00054a9a80001e7d_sp  tabdef ON (doc.r_object_id=tabdef.recid) where (doc.keynum like N'aaaaaaaaaaaaaaa%' and  ((doc.isdel=0) or (doc.isdel=1)) ) 
and (doc.i_has_folder = 1 and doc.i_is_deleted = 0) 
) dm_inline_view_1 
where dm_m.js93008,rnum >= 101   AND dm_rnum <= 200 order by 1 asc

431金融学综合考试大纲2013.doc

2.查询时间10s内

432统计学考试大纲2013.doc

select * from ( 
select all  doc.r_object_id "objid",doc.name,doc.number, doc.cuid, doc.r_creation_date, doc.security, doc.bordline, doc.twicedline, doc.dline, doc.keynum, doc.creator_name, 
doc.security_name, doc.dline_js4399金沙线路,name, doc.pid, doc.modifier_name, doc.tblcount, doc.r_modify_date, doc.prjdefid, doc.voldefid, doc.tabledefid,  doc.relation_id, 
doc.r_object_type "r_object_type", doc.bcode "bcode", doc.copycount, doc.securityapply, doc.pgholtime, doc.done, doc.disciplineid, doc.disciplineid_name, 
tabdef.fieldp2830b1886150468j, tabdef.fieldb7727l1886150454q, tabdef.fields5243t504621622q, tabdef.fieldt3385x504621623d, tabdef.fieldf3763y504621609s, tabdef.fieldk1536t504621614n, 
tabdef.fieldr1297k504621621z, tabdef.fieldb5089j1350775945q, tabdef.fieldk5874q1350775954t, tabdef.fieldb2206h1350775945a, tabdef.fieldf4308a1350775949v, tabdef.recid, 
CAST(ROW_NUMBER() OVER(ORDER BY doc.r_object_id asc ) as int) as dm_rnum 
from ps_fld_doctree_document_sp  doc 
LEFT OUTER JOIN tabledef00054a9a80001e7d_sp  tabdef ON (doc.r_object_id=tabdef.recid) where (doc.keynum like N'aaaaaaaaaaaaaaa%' and  ((doc.isdel=0) or (doc.isdel=1)) ) 
and (doc.i_has_folder = 1 and doc.i_is_deleted = 0) 
) dm_inline_view_1 
where dm_rnum >= 101   AND dm_rnum <= 200 order by 1 asc

433税务专业基础2013.doc

434国际商务专业基础2013.doc

436资产评估专业基础2013.doc

440新闻与传播专业综合能力考试大纲2013.doc

601高等数学考试大纲2013.doc

701美学原理考试大纲2013.doc

702民法学考试大纲2013.doc

703政治学考试大纲2013.doc

704马克思主义理论与实践考试大纲2013.doc

705语言文学基础与理论试大纲2013.doc

707新闻传播史论考试大纲2013.doc

715秘书学与行政管理考试大纲2013.doc

717公共管理学考试大纲2013.doc

801美学评论与写作考试大纲2013.doc

803西方经济学考试大纲2013.doc

804刑法学考试大纲2013.doc

805国际关系史考试大纲2013.doc

806思想政治教育理论与实践考试大纲2013.doc

807阅读与写作考试大纲2013.doc

809新闻传播业务2013.doc

811普通物理考试大纲2013.doc

813病理生理学考试大纲2013.doc

823电子技术基础考试大纲2013.doc

827管理运筹学考试大纲2013.doc

828管理学与微观经济学考试大纲2013.doc

829公共政策学考试大纲2013.doc

832现代汉语与公文写作考试大纲2013.doc

835包装工程综合考试大纲2013.doc

分享到: 微博推荐

本文由农业发布,转载请注明来源:2007年海洋与渔业信息第1,2013年暨南大学硕士研