I have a table which has around 50 columns. But there are only 6 columns on which we perform regular search. When I am trying to create a non clustered index on it I am getting the warning of 900 bytes. This would be a problem as we also do bulk update/inserts. So can onyone help me in finding a solution?
If I put few columns out of those 6 in INCLUDE, will that cause any performance issue?
Lets say the datatypes for the columns are -
ColumnA (nvarchar(255),null) ColumnB (Int, null) ColumnC (nvarchar(255),null) ColumnD (Datetime,Null) ColumnE (nvarchar(255),null) ColumnF (nvarchar(Max),null)
Primarily these columns are used in WHERE to pull out data.