Re: Can I create "private" index

From: Stanislav Kharab <skharab_at_interaccess.com>
>> to summarize - want to create an index on a table that only one user can use
 <<

No, you can not do this nor should you want to. If an index exists on a table  even if the index is in a schema different than the table the index is  available for all users of the table. The optimizer desides when to use the  index to help resolve a query. End users do not reference or see the index  unless they query the Oracle dictionary for index information, i.e.,  all_indexes, all_ind_columns etc...

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Sun Oct 12 1997 - 00:00:00 CDT