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);
>> >
>> >
