From: mcstockspamplug@spamdamenquery.com   
      
   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"  wrote in message   
   news:3fad8a1b$0$58711$e4fe514c@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 _   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)