Re: slow plan on join when adding where clause

No it is not, but that's not the issue I think - see my other posts.




On Mon, 12 Apr 2010 19:19:34 -0600, syan <kittylitter@people.net.au> wrote:

> Is the index clustered?

> On Thu, 2010-04-01 at 14:19 -0400, Mladen Gogala wrote:
>> Jasen, he does have the index, that precisely is a problem. According to
>> his statement, full table scan is faster than an index search.
>>
>> Jasen Betts wrote:
>> > On 2010-03-29, L. Loewe <lloewe@hotmail.com> wrote:
>> >
>> >> Hi all
>> >>
>> >
>> >
>> >> SELECT  * FROM  events, main WHERE  main.ti > events.start and
>> >>                                      main.ti < events.stop and
>> sensor_id=1;
>> >>
>> >
>> > create index main_ti_sid on main(sensor_id,ti);
>> >
>> >