What is Best Use for Primary Key?

ramfrom84 · New User Joined: 23 Aug 2006 Posts: 93 Location: chennai

Hi All,
In my table contains Six primary key.

I have value for three primary key.

What would be better Choice 1 or 2 , (consider the performance also)
1. Select query with three key value
2. Select query with any one key value

dick scherrer · Posted: Fri Jun 01, 2007 12:08 am

Hello,

Your request is quite unclear.

Please post the parts of the table definition that are involved with your question as well as sample queries that you are asking about.

ramfrom84 · New User Joined: 23 Aug 2006 Posts: 93 Location: chennai

Hi All,
Imagine the table with six primary key as general...

The table contains Six primary key. I have value for three primary key.

What would be better Choice 1 or 2 , (consider the performance also)
1. Select query with three primary key value
2. Select query with any one key value

Naresh Kumar Reddy P · New User Joined: 24 May 2007 Posts: 8 Location: Bangalore

Still your explanation is not clear. Can please give us an example?

dick scherrer · Posted: Fri Jun 01, 2007 7:08 pm

Hello,

Please provide the requested information.

Re-posting the original unclear request will get few useful replies.

We can provide suggestions, but you have to present something more solid to work with.

munikumar · New User Joined: 18 Apr 2007 Posts: 24 Location: India

As per my knowledge, if your table is vast in size then better to select with three primary key values.
But there is one problem, the number of index scans will be more, this leads to performance degradation.