table scan instead of index scan?

[Sven K�hler]

create table test(id1 int, id2 int, primary key (id1))
//
create index id2 on test(id2)

explain select * from test where id1=1

shows, that the select will use the "primary key index"
but

explain select * from test where id2=1

shows, that SAP DB will do a table scan, which is not really a good idea because it could use the index i created on id2.

it seems, that SAP doesn't use any other index than the primary one, but what do i have to do to enable index-use?

i'm using SAP DB 7.4.3.7 (aka 7.4beta)

Thx
Sven



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general