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);
>
>
>
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions