Re: Full table scan used instead of index?

>> > 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

>

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com