Re: slow plan on join when adding where clause

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

--

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