Re: Bind Variables ignoring Index on 10.2.0.4
Date: Wed, 09 Apr 2008 10:12:18 +0200
Message-ID: <fthtp2$5j2$1@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
Received on Wed Apr 09 2008 - 03:12:18 CDT