Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

There's more...

This example was chosen to show a more complicated computed column that demonstrates more than one concept at once. The other reason was to also show an example of something we sometimes want to avoid. Depending on the execution plan that's generated by the database engine, it is possible that the inline (subquery) select statement can be executed for each row that's returned from the main view. This is undesirable, but thanks to the intelligence of the database engine, this is not often the case. When a view seems to perform poorly, a computed column is often the cause.

Let's look at the view that we created in SQL Server Management Studio. Locate the AxDB database and locate the view from within the Views node. Right-click ...