Re: Oracle 7, Indexes

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" <info._remove_freek_at_xs4all.nl> wrote in message news:3fad8a1b$0$58711$e4fe514c_at_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 _
>
>
Received on Sun Nov 09 2003 - 15:14:32 CET