home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 659 of 2,288   
   Freek to All   
   Oracle 7, Indexes   
   09 Nov 03 01:28:20   
   
   From: info._remove_freek@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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca