is this query optimized?

[Sven Köhler]

select a.id_bundesland, b.bundesland from base_bundesländer a left join (select id_bundesland, bundesland from base_bundesländer_lang where id_sprache=1) b on (a.id_bundesland=b.id_bundesland) order by b.bundesland desc

is a common query in my application. i want to apply a WHERE-clause before the left-join takes place, so i need a sub-select.

explain tells me, that no indexes are used for joining.
this query still has some optimization potential.
all colums starting with id_ are indexed.
there's also a primary key on base_bundesländer_lang over the two colums (id_bundesland, id_sprache). so there should be enough stuff to optimize this query.

what can i do, to improve this query?
how does SAPDB's optimizer handle this case?


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