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
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.
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
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.
Previous Topic: Special characters
Next Topic: dblink error
Goto Forum:

Current Time: Wed Jul 26 09:54:16 CDT 2017

Total time taken to generate the page: 0.05759 seconds