Re: index unused

Yep. Right ou are.

On Mon, 12 Jan 2004 00:43:00 +0100, "Erik" <no_at_spam.com> wrote:

>> BTW : Having said that FBI's arent clever, I note that
>>
>> select *
>> from mytab
>> where somefunc( 4* col1 ) > 2000;
>>
>> Actually *does* use myidx, so the FBI definition does not alway have
>> to match the where clause exactly.
>>
>> Funny enough :
>>
>> select *
>> from mytab
>> where somefunc( col1 * 2 * 2 ) > 2000;
>>
>> will not use mydix, but this one will
>>
>> select *
>> from mytab
>> where somefunc( col1 * (2 * 2) ) > 2000;
>>
>> The cleverness of FBI's seems limited, so I wouldn't count on it. Any
>> opinions, anyone ?
>
>Yes, I guess the CREATE INDEX statement should read
>create index myidx on mytab(somefunc(col1 * 4));
>instead of
>create index myidx on mytab(col1 * 4)
>
>
Received on Sun Jan 11 2004 - 23:24:19 CST