如何加快光标 [英] How to Speed Up Cursor

问题描述

大家好，

我有一个游标，它由许多存储过程循环组成，最终给出了由500行和226列组成的输出.
任何人都可以指导我，从现在开始需要55分钟，我应该如何提高执行速度.

谢谢，
Kewal

Hi All,

I have a cursor which consist of many looping of stored procedures which finally gives output consisting of 500rows and 226 columns.
Can anyone please guide me how should I increase the speed of this execution as of now it is taking 55minutes.

Thanks,
Kewal

推荐答案

几乎每个游标都可以转换为CTE(通用表结构)，请尝试一下，我确信它将提高您的速度.我不知道它能带来多大的提升.但是我知道，您可以使用游标进行的所有操作都可以转换为CTE.

希望对您有所帮助.

Almost every cursor could be converted to CTE(Common Table Structure)s try it and I''m sure it will boost your speed. And how much it boosts I don''t know. But I know that everything that you can do with cursors could be converted to CTEs.

Hope it helps.

这篇关于如何加快光标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！