Using dereferenced virtual column - Performance optimization

Hi,

In my Orders table (which is child of Customers) I have 2 virtual columns:
One dereferences Customers Name: [Customer].[Customer_Name]
One dereferences  Customers Phone: [Customer].[Customer_Phone]

I want to add another virtual column in Orders that concatenates these two e.g. "John Smith - 5551234").

From a performance and best practices standpoint, is it better to:

Reference the two existing virtual columns I already created in Orders, or
Perform the dereferencing again in the new virtual column?

And also would it make a difference which order the columns are?

Many thanks

0 1 32
1 REPLY 1

Any difference would not be significant. 

Top Labels in this Space