Re: all_indexes / all_ind_columns

On Nov 27, 1:46 pm, zino <antony6..._at_gmail.com> wrote:
> what is the difference between all_indexes and all_ind_columns and
> which one should I refer to, to get all the defined indexes.

The first is about indices and the second is about columns in the indices. Which you use depends on whether you care about the columns and what else exactly you want to accomplish. Do a Describe on each (or examine them with your favorite tool if it isn't sqlplus) to see what you have to work with.

jg

--
@home.com is bogus.
"...frost keyboards across America..."
http://www.signonsandiego.com/news/business/20071127-1258-amazon-subpoena.html