Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query not using indexes

Re: Query not using indexes

From: Tony <andrewst_at_onetel.net.uk>
Date: 8 Jul 2004 02:52:04 -0700
Message-ID: <c0e3f26e.0407080152.415900a1@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US