Teradata PI and SI restrictions

Database

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
3 REPLIES
Teradata Employee

Re: Teradata PI and SI restrictions

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

Re: Teradata PI and SI restrictions

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

Teradata Employee

Re: Teradata PI and SI restrictions

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