如何优化耗时超过25秒的sql查询. [英] how to optimize sql query which is taken more than 25 sec.

问题描述

如何优化耗时超过25秒的sql查询.

how to optimize sql query which is taken more than 25 sec.

how to resolve it.

推荐答案

我们不确定您的查询内容是什么，请尽可能发布您的查询.通常，如果SQL查询包含函数，执行速度可能会很慢.如果查询文件不包含任何函数，则可以尝试将此查询转换为存储过程 [^ ] .存储过程可以提高性能.

问候
塞巴斯蒂安

We are not sure what''s in your query, Please post your query if possible. Normally SQL query execution can be slow if it contains functions. If your query dowsn''t contains any functions you can try converting this query to a stored procedure[^]. Stored procedures can give a performance boost.

Regards
Sebastian

这篇关于如何优化耗时超过25秒的sql查询.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！