Re: INDEX Use How?

From: Ken Friday <ken_friday_at_pleasantco.com>
Date: 1998/02/04
Message-ID: <01bd319c$de802080$8859a8c0@04653>#1/1

Karen,

In my experience you need to be explicit in the index create (using index syntax for key constraints) ddl. The user level default does not differ between object types. Other than that periodic monitoring and maintenance (e.g. move offending indexes) is about all you can do.

Ken F.

byrd_at_mscf.med.upenn.edu wrote in article <886612885.1590755333_at_dejanews.com>...
> We want to establish two tablespaces(one for tables and the other for
> indices). If we give users privileges to create an index via "create
> index" or create a table using a primary key, how can we guarantee that
> the indices reside in the established index tablespace by default? In
> other words how do we make sure all indices are where we want them to be.
>
> Karen Byrd
> Univ of Pa, School of Med.
> Computing and Info Tech
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Wed Feb 04 1998 - 00:00:00 CST