Dear reader,

My software supplier does not allow me to create an index on "their" tables.
Their point is that it can have a bad influence on the performance of
"their" forms, queries, things and so on.
However, for some reason, I need to make an index on certain columns in one
of "their" tables. At least, I want to search on certain columns that are
not indexed.
One option is to copy the relevant part of the table to a table of my own an
create an index. But, that costs a lot of space, data can be old, you have
to refresh etc.
By the way, running on Oracle 7, next year that will be 8.

I hope their is some way of making an index invisible to other users or
something like that.

Does anyone have an suggestion ?

Thanks in advance!

Kind regards,
Freek

A certain part of my email adres needs to be removed incl the _

You don't need an index to search on a given column. The index needs only to
be created to make the search faster; under certain conditions. I said under
certain conditions because in some cases it is faster to do a full table
scan.

The reason that your software supplier does not want you to create an index
is because it may slow down the queries performed by their application. Or
if a lot of data insertion is performed (such as bulk inserts) they can be
slowed down by the index.

If you really need this index, create it (and don't tell the software
supplier). Then check how it affects the system and whether you are prepare
to put up with any impact that it may have. If you are not prepare to put at
with its impact, just drop the index.

Futures versions of Oracle do not hide the index for "other" users. The
index is a property of the table and is part of the schema that owns the
table.

David

"Freek" <info._remove_freek (AT) xs4all (DOT) nl> wrote