Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Describing indexes of a table in OCI
Uwe Schneider <uwe_at_richard-schneider.de> wrote in message news:<3C273DEA.453B6349_at_richard-schneider.de>...
> andras wrote:
> >
> > Hello to you all,
> >
> > I would like to get a description of all indexes of a specific
> > table. I have seen the 'table description' structure for
> > OCIDescribeAny() in the docs so I am aware of the node structure
> > and I also am able to describe the columns of a table without
> > problems.
> >
> > My specfic question to you is what OCIAttrGets and OCIParamGets
> > should I use to access 'statistics' -> 'indexes' -> ... from the
> > describeTableHandle.
> >
> > I have tried to figure it out from the header file but I could
> > find no OCI_ATTR_LIST_STATISTICS, OCI_ATTR_LIST_INDEX or anything
> > like that.
>
> Why don't you just query the data dictionary?
>
> -> user_indexes, user_ind_columns ...
Are there any ideas about performance comparasion?
-- Sergey SikorskiyReceived on Mon Dec 24 2001 - 13:57:16 CST