All Forums Database
rajan-3797 14 posts Joined 01/07
01 Jun 2009
Teradata PI and SI restrictions

We know that we cannot include more than 64 columns in PI or SI definition.Can somebody come up why exactly this restriction.Thanks in advance,raj

Adeel Chaudhry 773 posts Joined 04/08
01 Jun 2009

Hello,Perhaps because you may not encounter such versatile entity, which may not be normalized, may not be divided into sub-tables and contains more than 64 columns which are strong candidates for index!And please note, indexes are not equal to keys!Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

rajan-3797 14 posts Joined 01/07
01 Jun 2009

Hi Adeel,I am aware that there may not be a case wherein you will have more than 64 columns in your index definition.Actually I am looking for what is causing(limitation) Teradata to define this restriction.-Raj

Adeel Chaudhry 773 posts Joined 04/08
01 Jun 2009

Well, I would say there has to be some limit .... it cannot be unlimited .... as a matter of fact it wont make any sense and use as well!As compared to Oracle 11g or DB2 version 8, still Teradata 64 columns is way higher than Oracle's (30 for bitmap index and 32 for all others), DB2's (16 columns)!For exact technical level reason, I guess contacting Teradata directly will be the best bet! :)Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.