Home » RDBMS Server » Server Administration » Create B*Tree cluster for existing tables
Create B*Tree cluster for existing tables [message #218813] Sat, 10 February 2007 12:10 Go to next message
rpk2006
Messages: 1
Registered: February 2007
Location: India
Junior Member
I am using 9i R2. I have some tables but later I read that B*Tree clustering increases database performance and reduces I/O overhead. I therefore want to add clustering to existing tables and create more tables with B*Tree clustered index.

Please let me know how can I add this to existing tables.

Report message to a moderator

Re: Create B*Tree cluster for existing tables [message #218817 is a reply to message #218813] Sat, 10 February 2007 14:18 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
First you should really decide if using a CLUSTER is the right thing in your circumstances. Although CLUSTERs can provide a performance benefit if the circumstances are appropriate, they may also be detrimental to performance. You may want to read over Using Clusters to validate it's use in your environment.

To create a CLUSTER review CREATE CLUSTER.

Report message to a moderator

Previous Topic: Special characters
Next Topic: dblink error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 09:00:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.