Re: Primary key efficiency

From: "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in>
To: Russell Shaw <rjshaw(at)iprimus(dot)com(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Primary key efficiency
Date: 2004-01-25 11:22:42
Message-ID: 4013A702.3080608@sancharnet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jabber(dot)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.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bill Moseley 2004-01-25 16:40:27 Re: Hierarchal data
Previous Message Russell Shaw 2004-01-25 11:06:01 Primary key efficiency