Database Reference
In-Depth Information
Figure 14-2.
UDT performance: Querying the data
Figure 14-3.
UDT performance: Computer Scalar operator properties
Some of the performance issues can be addressed with persisted computed columns, which can even be indexed
if needed. Let's test this by adding a
State
column to the
AddressesCLR
table and creating the indexes in both tables.
The code for doing this is shown in Listing 14-6.