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 _
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 _