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
Any difference would not be significant.
User | Count |
---|---|
16 | |
8 | |
6 | |
3 | |
2 |