Re: questions RE column data types
Posted by:
Rick James
Date: December 22, 2015 07:31PM
* When a tmp table is needed for a complex SELECT, VARCHAR(255) becomes CHAR(255), thereby taking lots more space than necessary. This either slows things down or leads to spilling to disk which significantly slows things down.
* Big VARCHARs can lead to hitting limits that are based on the max _possible_ space needed.
* (There may be more things.)
Subject
Views
Written By
Posted
1344
December 21, 2015 09:39PM
699
December 21, 2015 11:50PM
842
December 22, 2015 07:06AM
790
December 22, 2015 04:28PM
Re: questions RE column data types
781
December 22, 2015 07:31PM
675
December 22, 2015 08:18PM
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.