Re: "Index column size too large" on a select statement?
Posted by:
Colin Kish
Date: January 11, 2018 04:15AM
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).
Subject
Written By
Posted
Re: "Index column size too large" on a select statement?
January 11, 2018 04:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.