Re: Primary key efficiency

Поиск
Список
Период
Сортировка
От V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Тема Re: Primary key efficiency
Дата
Msg-id 4013A702.3080608@sancharnet.in
обсуждение исходный текст
Ответ на Primary key efficiency  (Russell Shaw <rjshaw@iprimus.com.au>)
Список pgsql-novice
Dear Russell Shaw ,

> Hi,

Hello

>
> Is a long field ok for a primary key, or should i use
> a unique integer?:

Unique Integer  is the most preferable thing as this retrive your data
at faster.
All said , if your select queries would use this primary key  for
identifying  tuples then better use integer


--
Regards,
Vishal Kashyap

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
I Know you believe my words so logon to Jabber.org
and add vishalkashyap@jabber.org to your roster.
~*~*~*~*~*~*~*~*
I am usually called as Vishal Kashyap
but my Girlfriend calls me as Vishal CASH UP.
This is because others identify me because of my generosity
but my Girlfriend identify me because of my CASH.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*


В списке pgsql-novice по дате отправления:

Предыдущее
От: Russell Shaw
Дата:
Сообщение: Primary key efficiency
Следующее
От: Bill Moseley
Дата:
Сообщение: Re: Hierarchal data