Datatype for Primary Index in a table.

Database

Datatype for Primary Index in a table.

Hi Forum,

How much of a difference does the data type of the Primary index make. For example if the PI is Integer/Decimal or Varchar/Char data type. Does this affect the performance and how.

TIA.
1 REPLY

Re: Datatype for Primary Index in a table.

I guess, Hashing algorithm will take more time to generate HASH Value, if the size of Primary Index is too large.