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