Primary Key

Hi,

Can someone give me advice ( or link to a webpage ) about how can I use
primary key in my database and how can I use it for optimizing the
speed of my database.

Thanks.<John.Arthur@.gmail.com> wrote in message
news:1113816552.184862.262490@.z14g2000cwz.googlegr oups.com...
> Hi,
> Can someone give me advice ( or link to a webpage ) about how can I use
> primary key in my database and how can I use it for optimizing the
> speed of my database.
> Thanks.

This article describes how to choose a primary key:

http://www.windowsitpro.com/SQLServ.../5113/5113.html

In theory, a primary key exists for logical reasons (data entegrity) not
physical ones (performance), but primary keys in MSSQL are implemented with
an index (clustered by default), so you can look into how indexes improve
performance. There's lots of information in Books Online, and this site has
more details:

http://www.sql-server-performance.com/
http://www.sql-server-performance.com/q&a5.asp

Simon