I have a query that uses around 6 or 7 tables and uses pivot to return a formatted string from this entire structure. Actually, today this query is dynamically generated via C#/Entity Framework and it takes at least one minute to process and return 10 rows.
We were looking for alternatives so we can improve the performance of this query, and we found the virtual columns. We could not find any benchmark comparing virtual columns and view so we can argue with our client which option we'll choose.
If we opt for virtual columns, will it run automatically the function linked to it? Or it needs to be queried to have its value "filled"?