Re: Varchar Memory Usage
Interesting!
I can't explain what you are seeing, but might have a 'fix':
Change varchar(256) to varchar(255)
Temp tables, such as the subqueries you are trying either become MEMORY tables or MyISAM tables. There are many rules on when it uses the more efficient MEMORY, one of them being the size of VARCHARs. 256 is, I think, too big; 255 is ok.
Another factor is the CHARACTER SET of the string fields.
Subject
Written By
Posted
Re: Varchar Memory Usage
July 30, 2013 09:10PM
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.