1) no indexes are invisible, you can't hide them from the object's owner
2) it's not clear in your post if you realize that you don't need an index
on a column in order to search for a value in that column -- the index is
only necessary for uniqueness (not the case here) or potentially for
performance improvement
3) if there is no way physically or politically that you can create an
index, you need to balance the benefits of an index (which would require in
this case, cloning the table and creating the index) with the cost of
maintaining a the additional table and index(es) -- if you run reports
often, and it's ok for the data to be somewhat out of date, then it may be
worth the processing cost to create the other table -- however, it sounds
like it's probably not going to be worth the effort.
4) if your analysis under #3 indicates the index is valuable, you need to
present your case to your vendor -- a reasonable vendor should be willing to
discuss stuff like this -- however, if they're still running on Oracle 7,
their Oracle savvy and reasonableness is a bit suspect
-- mcs
"Freek" <in****************@xs4all.nl> wrote in message
news:3f***********************@news.xs4all.nl...
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 _