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
|