开发者

Compiler in SQL Server [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

What is the meaning of Stored procedures are “pre compile开发者_Python百科”?

I read that stored procedures in SQL Server are compiled before they are executed. AFAIK, a compiler is used to translating high-level language into machine language or some kind of intermediate language (such as .NET IL code). So I am wondering what does SQL Server compiler do? What is a stored procedure compiled into?

Thanks.


Compiling a query is the process of creating an Execution Plan. Compiled execution plans are cached and re-used every time a query executes.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜