Hi,

We have a table in the database having CHAR as the key Columns. In few of the forums, I learnt that Netezza provides better performance with Integer Data Type as Key Column while selecting the record or updating the record.

I tried both the options(i.e using CHAR and Integer Data Type) but didn't find any difference in the performace.

Can you please explain me the what can be reason for that?

Regadrs

NM