Re: Full table scan used instead of index?

From: Thomas Hyldgaard <hyldgaard_at_hotmail.com>
Date: 21 Aug 2001 12:46:52 -0700
Message-ID: <62b0a667.0108211146.182d3e99_at_posting.google.com>


Well we final found the problem:
From Java we used strings for the column. When the HEXTORAW function in the SQL query then the index is suddenly used.

Best regards
Thomas

Robert Fazio <dbabob_at_yahoo.nospam.com> wrote in message news:<Xns90FE4D4F3348Fdbabobyahoocom_at_24.12.106.199>...
> >> > The table is creates as:
> >> > CREATE TABLE(c raw(32),t raw(32));
> >> >
> >> > Can indexes work on the raw(32) data type?
>
>
> I really don't think so. It never worked on longs, and I don't believe it
> works on raw. I am actually suprised that it even created the index at all.
> Or that't the question that should be asked. You did create an index,
> right?
>
> >> >
> >> > Best regards
> >> > Thomas
> >
Received on Tue Aug 21 2001 - 21:46:52 CEST

Original text of this message