[vc_row][vc_column][nz_btn text=”Software Elegance” link=”http://casthighlight.wpengine.com/category/product/indicators-methodology/software-elegance” icon=”icon-dashboard” color=”black” shape=”rounded”][nz_btn text=”Code Complexity” link=”http://casthighlight.wpengine.com/category/product/indicators-methodology/software-elegance/code-complexity/” icon=”icon-code” color=”black” shape=”rounded” type=”ghost” hover_ghost=”screen”][vc_empty_space height=”12px”][vc_empty_space height=”12px”][vc_row_inner][vc_column_inner width=”1/2″][vc_column_text]

Why you should care

[/vc_column_text][vc_column_text]

Developers do not recommend mixing DDL and DML Operations. They are generally avoided because such mxing can cause a Recompile which results in resetting the code differently and causing a mess in the process. It is recommended to place all DDL statements at the top of the stored procedures and perform the necessary query work.

[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_column_text]

Business Impacts

It is advised that DML and DDL operations should not be mixed as they can slow down the innovative qualities of the code and cause loss of time. It also makes it unsuitable for clients to utilize a slower version of an otherwise well written code.[/vc_column_text][vc_empty_space height=”12px”][nz_btn text=”Acceleration” link=”http://casthighlight.wpengine.com/category/product/indicators-methodology/acceleration/” icon=”icon-office” color=”orange” shape=”rounded” hover_normal=”opacity”][/vc_column_inner][/vc_row_inner][vc_empty_space][vc_single_image image=”5362″ img_size=”full”][vc_row_inner][vc_column_inner width=”1/2″][vc_column_text]

CAST Recommendations

[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_column_text]

References

https://ubitsoft.com/help_19/html/6aad3a30-a429-4e4c-bbb8-2ef1a0fef14e.htm[/vc_column_text][nz_btn text=”Style Guide” link=”https://github.com/Kristories/awesome-guidelines” icon=”icon-book” color=”turquoise” shape=”rounded” type=”ghost” hover_ghost=”screen”][/vc_column_inner][/vc_row_inner][vc_separator][vc_column_text]

How we detect

[/vc_column_text][vc_column_text]

This code insight establishes that functions, procedures and triggers should not have too many parameters. Depending on thresholds observed in the benchmark of thousands of applications and billions lines of code, Highlight accounts penalty points to the given scanned files.

[/vc_column_text][vc_row_inner][vc_column_inner][vc_single_image image=”5362″ img_size=”full”][vc_column_text]

[/vc_column_text][vc_empty_space height=”16px”][nz_btn text=”See features” link=”http://casthighlight.wpengine.com/outputs-analytics/” icon=”icon-stats” color=”black” shape=”rounded”][nz_btn text=”How it works” link=”http://casthighlight.wpengine.com/how-it-works/” icon=”icon-cog” color=”black” shape=”rounded” type=”ghost”][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]