469,890 Members | 2,164 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

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.

Jul 23 '05 #1
1 1132

<Jo*********@gmail.com> wrote in message
news:11**********************@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/SQLServe...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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by John Simmons | last post: by
5 posts views Thread by Ghulam Farid | last post: by
9 posts views Thread by 101 | last post: by
18 posts views Thread by Thomas A. Anderson | last post: by
4 posts views Thread by Peter | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.