优化sql用到的方法
2024-09-29 11:59:40
set statistics profile on
set statistics io on
set statistics time on
declare @begin_date datetime
declare @end_date datetime
select @begin_date = getdate()
select @end_date = getdate()
select datediff(ms,@begin_date,@end_date) as '用时/毫秒'
set statistics profile off
set statistics io off
set statistics time off
最新文章
- to_string()的应用
- 30-Razor语法基础
- Example_07_05录音提示open failed: EACCES (Permission denied)
- [Hapi.js] Request Validation with Joi
- 第11章 享元模式(Flyweight Pattern)
- phpcms 2008 后台发文章chrome和firefox文章不能上传图片的问题
- HTML+CSS D08浮动
- 浅酌iOS 11兼容性
- inotify+rsync实现实时同步
- 常见Css样式
- mysql进阶(九)多表查询
- pd16.5增加字段备注
- 使用Python开发chrome插件
- LeetCode:145_Binary Tree Postorder Traversal | 二叉树后序遍历 | Hard
- boke练习: spring boot: security post数据时,要么关闭crst,要么添加隐藏域
- 56_实现类似spring的可配置的AOP框架
- LMS算法
- 最全的Spring AOP
- Daily Scrum meeting 2015.11.9
- Coursera课程《Python数据结构》中课件