Re: SELECT SQL

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 24 Apr 2007 00:14:20 -0700
Message-ID: <1177398860.367293.235090@t38g2000prd.googlegroups.com>

On 24 abr, 08:39, beerora <beersa.bee..._at_gmail.com> wrote:
> Hi,
>
> I have a following SQL query.
>
> Select a.id,a.name,a.age,a.class,a.tel from table01 a, table02 b
> where a.name=USER and (a.id=b.id01 or a.id=b.id02 or a.id=b.id03 or
> a.id=b.id04 or a.id=b.id05 or. a.id=b.id06)
>
> The above query took long time.
>
> How can I optimize this for better result?
>
> Thanks.

Oracle version? OS version? Num rows? Indexes? Query Plan? How much time is 'long time'?

No crystall ball over here.

Cheers.

Carlos. Received on Tue Apr 24 2007 - 02:14:20 CDT