Re: "Index column size too large" on a select statement?

[Colin Kish]

Okay figured this one out. I have a Column A varchar(100) on Table A then I place View A over it and place a function on column A which returns a very long string if I then use Column A from the View in a complex sub-query where it is used in both joins and group by's then the query optimiser must attempt to place some sort of temporary index on the column, and thus it throws a "Index column size too large" error. My solution was to convert column A in the view to a char(100).