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(at)people(dot)net(dot)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(at)hotmail(dot)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);
>> >
>> >