Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: performance tuning questions: replace IN (values) by JOIN

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

From: Bob Hairgrove <rhairgroveREMOVE_at_THISbigfoot.com>
Date: Sat, 30 Aug 2003 19:06:25 GMT
Message-ID: <3f50f582.36491101@news.webshuttle.ch>


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 Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com
Received on Sat Aug 30 2003 - 14:06:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US