Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query not using indexes
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<%%%Gc.42296$IQ4.3398_at_attbi_s02>...
> What data type is fieldB? Is it a string? Is the 'xxx' the actual value
> you are searching on or is it something like '%xxx'?
Good point! I've often been caught out by our database because for some weird reason they decided to make all sequence-based surrogate keys into VARCHAR2(10). So I go into SQL Plus and do "select * from bigbigtable where bbt_id=123456" and wonder why I have to wait... :-( Received on Thu Jul 08 2004 - 04:52:04 CDT
![]() |
![]() |