computed column Archives

Index on computed column

2 Comments / SQL Server / Gopal Krishna Ranjan / Sep 8, 2015 / computed column, index, indexing techniques

Today, we are going to learn how we can create index on a computed column which improves the performance of SELECT queries. To create a computed column, we will use an user defined function instead of inline code. Also to know about computed columns, refer my previous blog post “What is Computed Column in sql server“. Create index […]

Index on computed column Read More »

What is Computed Column in sql server

Computed column is a virtual column in sql server, which is not stored physically in the table. It’s data is not materialized in the database and gets calculated during query execution on that column. It takes it’s value from an expression and that expression can contain other columns to calculate a new value for the