how to specify join strategy and index

[?? ? <su...@msn.com>]

Hi, developers

>From the documentation, we know if we don't like the join strategy and index 
choosed by derby system for us, users can speicfy their own.

But how to specify join strategy or index when querying over derby?
in query statement? or anywhere else?

If anyone konw, please give me an exmaple.
Thanks.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

Re: how to specify join strategy and index

[Satheesh Bandaram <sa...@Sourcery.Org>]

Derby doesn't have a way specify join strategy or index. There has been
some discussion on this topic in the past, but currently Derby doesn't
support 'optimizer-hints' or 'optimizer-overrides'. Some of the previous
postings include:

http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200412.mbox/%3c41C3864A.5030103@Mutagen.Net%3e
http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200412.mbox/%3c41C7710F.3090103@sbcglobal.net%3e
http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200412.mbox/%3c41C360A6.3050400@Sourcery.Org%3e

Satheesh

?? ? wrote:

> Hi, developers
>
>> From the documentation, we know if we don't like the join strategy
>> and index 
>
> choosed by derby system for us, users can speicfy their own.
>
> But how to specify join strategy or index when querying over derby?
> in query statement? or anywhere else?
>
> If anyone konw, please give me an exmaple.
> Thanks.
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's
> FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
>