Re: Bind Variables ignoring Index on 10.2.0.4

"Holger Baer" <baer_at_dont_ask.com> schreef in bericht news:fthtp2$5j2$1_at_news.belwue.de...
> Pat wrote:
>>>What is the status of the index?
>>
>>
>> Looks valid as far as I can tell. Am I missing something?
>>
>
> Apart from the fact that the index in question is called sys_id and
> doesn't show
> up in this list? ;-)
>
>> SQL> select index_name, index_type, status, uniqueness from
>> user_indexes where index_name like 'SYS_TRIGGER%';
>>
>> INDEX_NAME INDEX_TYPE STATUS UNIQUENES
>> ------------------------------ --------------------------- --------
>> ---------
>> SYS_TRIGGER_INDEX1 NORMAL VALID NONUNIQUE
>> SYS_TRIGGER_INDEX3 FUNCTION-BASED NORMAL VALID NONUNIQUE
>> SYS_TRIGGER_REF6 FUNCTION-BASED NORMAL VALID NONUNIQUE
>> SYS_TRIGGER_REF8 FUNCTION-BASED NORMAL VALID NONUNIQUE
>> SYS_TRIGGER_SYSID FUNCTION-BASED NORMAL VALID UNIQUE
>>
>
> Cheers,
> Holger

I Thought it was sys_trigger_sysid...

Shakespeare Received on Wed Apr 09 2008 - 04:59:24 CDT