RE: [OJB-developers] sql syntax optimalisation hints

[Matthew B. <ma...@so...>]

We've been talking about this at work, and it's something we *eventually*
want to do.

I think this is more complex than general SQL tweaking to support different
platforms, as you need to map the "common" bits of the hints to a general
syntax or set of object attributes.

Who has the expertise to figure out this part? Bram, sounds like you might
be the man :)

m

-----Original Message-----
From: bram [mailto:br...@in...] 
Sent: Thursday, May 02, 2002 3:44 PM
To: obj...@li...
Subject: [OJB-developers] sql syntax optimalisation hints

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







_______________________________________________________________

Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: ban...@so...
_______________________________________________
Objectbridge-developers mailing list
Obj...@li...
https://lists.sourceforge.net/lists/listinfo/objectbridge-developers