Re: performance tuning questions: replace IN (values) by JOIN

On Sun, 31 Aug 2003 08:26:08 GMT,
=?ISO-8859-1?Q?J=E9r=F4me_Lacoste_-_CoffeeBreaks?= <lacostej_at_coffebreaks.org> wrote:

>Bob Hairgrove wrote:
>> On Sat, 30 Aug 2003 18:15:23 GMT,
>> =?ISO-8859-1?Q?J=E9r=F4me_Lacoste_-_CoffeeBreaks?=
>> <lacostej_at_coffebreaks.org> wrote:
>>
>> [snip]
>>
>>>But the index on the TIMESTAMP column doesn't seem to be used.
>>
>>
>> did you try using a hint?
>
>Bob,
>
>I had rather not add an hint to the request, as I am supposed to be
>running my queries from Java throught JDBC and, afaik, I am not sure it
>will make my code cross-platform without adding DB detection, which I
>would rather avoid. I am testing this right now to find it out.
[snip]

But a hint is just a special kind of comment ... other RDBMS will just ignore it.

--
Bob Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com