Re: [Hsqldb-user] Index in Hsql - am i wrong..??

[indianscorpio <coo...@gm...>]

MY BAD... indexing only works while searching i.e where etc not group by
right..??

indianscorpio wrote:
> 
> Hi 
> 
> I created a index on 3 fields and later did explain plan for:
> - create table1
> - created index1 on table1 (fld1, fld2, fld3)
> - EXPLAIN PLAN FOR ( select fld1, fld2, fld3 from table1 GROUP BY (fld1,
> fld2, fld3))
> 
> the output for explain plan returns index = SYS_IDX_53 [Hidden].
> Shouldn't it be index1. ?? 
> 
> Or am i doing something wrong
> 

-- 
View this message in context: http://www.nabble.com/Index-in-Hsql---am-i-wrong..---tp22800593p22801346.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.