Re: Source of expensive SQL

Hi Wolfgang,

        FYI, It seems "cooperative index method" is another term for domain indexes.

        The only type 9 index on my instance is XDB.XDBHI_IDX which is of type XDB.XDBHI_IDXTYP. Cheers,
Tim

> Not sure if it helps, but wouldn't "bitand(i.flags, 256)" and
> "bitand(i.flags, 512)" be the same as 0x100 and 0x200 below
> (from sql.bsq):
>
> From the same source:
>
> /* cooperative index method : 9 */
>
> PS. Anyone know what a "cooperative index method" is?
>

--
http://www.freelists.org/webpage/oracle-l