Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX Use. How?

Re: INDEX Use. How?

From: Jerry Gitomer <jgitomer_at_p3.net>
Date: 1998/02/05
Message-ID: <34D95996.59EE@p3.net>#1/1

Hi Karen,

Even if you could find a way to force users to put their tables and indexes where you want them placed you can still run into serious performance problems if you wind up with fragmentation and row chaining.

One way to avoid the problems is to arrange to have the users email you the create statements and provide an estimate of the number of rows they expect in the table. You would then have the opportunity to specify the tablespace and storage clauses so that performance problems due to poor structure could be eliminated.

Regards

Jerry

Karen Byrd wrote:
>
> We want to establish two tablespaces(one for tables and the other for indices).
> If we give users the privileges to create an index via "creat index"
> or create tables using a primary key how can we guarantee where the
> indices are created by default? In other words we want all indices to
> reside in the tablespace we are going to set up for them every time.
>
> TIA
>
> --
> Karen Byrd
> Univ. of PA, School of Med.
> Computing and Information Technology
> byrd_at_mscf.med.upenn.edu
  Received on Thu Feb 05 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US