Home » SQL & PL/SQL » SQL & PL/SQL » Clustered index on primary key columns (11 G, Linux)
icon2.gif  Clustered index on primary key columns [message #621476] Wed, 13 August 2014 10:59 Go to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member

Hello,

Can primary key columns be the part of cluster index?

I am desiging a DB and having the same columns for multiple tables, Thus i want to create a cluster and cluster index for the same. Below example may help here to understand this issue.
Tables TRN_CLIENTS, TRN_VITAL,TRN_XYZ...etc are sharing the same columns and column values (Batch id {number}, Request_id {number}). These both columns are appearing as PRIMARY KEY in the respective tables.

Now I want to create a cluster and cluster index for the same.

Seeking your advice for
1. As my primary keys columns are having implicit indexes itself, will the extra cluster index not be EXTRA BURDON for DML/Select?
2. Cause primary key is logical concept but cluster index is physical concept, it will increase the performance?

[mod-edit] removed font. too small for my eyes.

[Updated on: Wed, 13 August 2014 12:33] by Moderator

Report message to a moderator

Re: Clustered index on primary key columns [message #621478 is a reply to message #621476] Wed, 13 August 2014 11:01 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>Can primary key columns be the part of cluster index?

what happens when you try to do so?
Re: Clustered index on primary key columns [message #621583 is a reply to message #621478] Thu, 14 August 2014 11:27 Go to previous messageGo to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member

Hi,

Just a small update,

I can create clustered index on primary key columns..

Now the question here, When Cluster index will be faster then b-tree index..?
Re: Clustered index on primary key columns [message #621584 is a reply to message #621583] Thu, 14 August 2014 12:02 Go to previous message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The index of the cluster is B*Tree unless you create a hash cluster.


[Updated on: Mon, 18 August 2014 12:49]

Report message to a moderator

Previous Topic: How to Send E-Mail in Oracle(PL-SQL) very urgent please
Next Topic: Item Validation
Goto Forum:
  


Current Time: Sun Sep 21 23:15:33 CDT 2014

Total time taken to generate the page: 0.10921 seconds