19

As always I used to create ordinary stored procedures regarding the second option for creating stored procedure called "Natively Compiled Stored Procedure" I wanna know if there is any performance benefit to using compiled one?

Is there anyone can Help to find out? Thanks

msd
  • 591
  • 7
  • 23
  • 2
    Why down vote? Please leave a comment after down voting – msd Jul 01 '17 at 12:27
  • 1
    I'm not the downvoter but I the documentation link that answers your question is the first result in the google search https://www.google.com/#q=Natively+Compiled+Stored+Procedure – Dan Guzman Jul 01 '17 at 12:58
  • 4
    Could someone please explain it better? Why and when someone should use natively compiled stored procedures? – AskMe Oct 10 '17 at 13:37

1 Answers1

11

Stored procedures that are marked with NATIVE_COMPILATION are natively compiled. This means the Transact-SQL statements in the procedure are all compiled to native code for efficient execution of performance-critical business logic.

For more information, see Native Compilation of Tables and Stored Procedures

KyleMit
  • 30,350
  • 66
  • 462
  • 664
Mustafa taha
  • 134
  • 1
  • 4