怎样得到执行一条SQL语句所花费的时间？

drunkboy 2004-05-02 04:03:31

RT

...全文

65 回复打赏收藏转发到动态举报

写回复

回复

切换为时间正序

请发表友善的回复…

发表回复

oracle中如果需要得到一条SQL语句的执行时间可以用如下2种方式代码如下: SQL> set timing on; SQL> select count(*) from wea; COUNT(*) ———- 39490 已用时间: 00: 00: 00.06 SQL> select sql_text, elapsed_time from v$sql 2 where sql_text like ‘select count(*) from wea’; 未选定行已用时间: 00: 00: 00.25 您可能感兴趣的文章:ORACLE时间函数(

今天小编就为大家分享一篇PHP获取MySQL执行sql语句的查询时间方法，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧

he SQL Trace, which is part of the Performance Trace (transaction ST05), is the most important tool to test the performance of the database. Unfortunately, information on how to use the SQL Trace and especially how to interpret its results is not part of the standard ABAP courses. This weblog tries to give you a quick introduction to the SQL Trace. It shows you how to execute a trace, which is very straightforward. And it tells how you can get a very condensed overview of the results--the SQL statements summary--a feature that many are not so familiar with. The usefulness of this list becomes obvious when the results are interpreted. A short discussion of the ‘database explain’ concludes this introduction to the SQL Trace.

代码如下: USE NBDXMIS CREATE proc TestTimeAnySentence @sql_where varchar(8000) as declare @ct datetime set @ct = getdate() declare @newsql_where varchar(8000) set @newsql_where=@sql_where exec(@newsql_where) select datediff(ms, @ct ,getdate()) as ‘查询时间（毫秒）’ go TestTimeAnySentence ‘select * from 水费表 wher

主要介绍了MySQL中使用show profile命令分析性能的用法整理,show profiles是数据库性能优化的常用命令,需要的朋友可以参考下

34,872

社区成员

254,640

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章