Re: SELECT SQL

From: beerora <beersa.beersa_at_gmail.com>
Date: 24 Apr 2007 00:48:27 -0700
Message-ID: <1177400907.315570.173060@n35g2000prd.googlegroups.com>

On Apr 24, 3:14 pm, Carlos <miotromailcar..._at_netscape.net> wrote:
> 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.

Sorry Carlos,

Oracle client Version 9, OS WinXP, About 6 million rows, index on a.name. Received on Tue Apr 24 2007 - 02:48:27 CDT