[OJB-developers] sql syntax optimalisation hints

[bram <br...@in...>]

Hi,

Is there a way to add optimalisation hints (database dependend) to the
query's?


Like the rule in oracle

select /*+ rule*/ [colomn list] from [table list]

Where rule is for example "HASH_AJ" or "INDEX( tab index )"



Or the "options" in MsSQl2k

Select * from a, b, c
Option(force order, loop join)




I know that the SqlGenerator generates sql92 compliant sql and that the
database dependancies are minimalized to type mappings (eg BIT to int
for MySql), but if with some pointers I could do it my self