OraFAQ Forum: Server Administration » Create B*Tree cluster for existing tables

Home » RDBMS Server » Server Administration » Create B*Tree cluster for existing tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create B*Tree cluster for existing tables [message #218813]

Sat, 10 February 2007 12:10

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:45:05 CDT 2024