开发者

Compiler in SQL Server [duplicate]

开发者 https://www.devze.com 2023-03-26 18:58 出处:网络
This question already has answers here: Closed 11 years ago. Possible Duplicate: What is the meaning of Stored procedures are “pre compile开发者_Python百科”?
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

精彩评论

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

关注公众号