 |
 |
Archives of the TeradataForum
Message Posted: Tue, 22 Feb 2005 @ 08:57:56 GMT
| Subj: | | Re: Default charset in volatile tables |
| |
| From: | | Victor Sokovin |
| | We have noticed that despite all the system defaults being Latin, when creating a volatile table in the following manner the column with
the case statement gets created with Unicode character set which causes poor performance in subsequent joins. | |
Default character set for string *literals* is Unicode. Try to specify Latin explicitly for the 'Y' and 'N' literals you are using in the table
definition.
Regards,
Victor
| |
