TD Version differences


TD Version differences


Could anyone tell the major differences between the TDv13 & v14. I referred some of the teradata docs

but some of them are detailed and has only few differences for database v14.

Just wanted to make sure that i am not missing anything. If you have any docs that summarises the difference across all TD versions

please share it with me. Thanks in advance,


Re: TD Version differences

New functio in teradata 14.20:-Dense_rank(ANSI),Median,To_number,NVL,Decode

New Data type :-Number(similar to oracle 38 digit long)

BLOCK Size is increased to 1 MB from 127.5 kb

Compression:-Using mvc and alc compression time and timestamp column can be compressed.

column can have unicode character as well

Re: TD Version differences

For ease of referrals , I keep few links. Will the below links  be helpful , since you are looking at high level?

Again releases are there in 14......

At more detailed level, it will be huge really.


Re: TD Version differences

Try the release notes of 13-10 and 14-00. The Summary includes all differences between 13-00 and 14-00.

The ReleaseNotes are part of the Documantation, available at

13-10 ->

14-00 ->

Re: TD Version differences

Thanks everyone for the details.