CLR provides the execution environment for all .NET Framework code, and allows using all of the available .Net languages, such as VB.NET or C#, for creating stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates. Code that runs within the CLR, which is referred to as managed code, compiles to native code prior to execution, thereby helping to achieve significant performance increases in certain scenarios.
The process the SQL Server Query Optimizer uses for determining how a query or stored procedure is executed. During a compile, the Query Optimizer examines the query, including the tables, clause conditions, joins, sub queries, sort and grouping requirements used. The Optimizer then takes into account all of the existing indexes, locking methods and join algorithms that could help the query run faster. The result of this process is what the SQL Server Query Optimizer considers to be the fastest way of executing the query. This is known as the execution plan.
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center