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/[EMAIL PROTECTED] http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200412.mbox/[EMAIL PROTECTED] http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200412.mbox/[EMAIL PROTECTED] 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/ > > >
