Re: slow plan on join when adding where clause

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