Re: Differentiating results of SELECT query

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 13 Dec 2006 01:49:40 -0800
Message-ID: <1166003380.768395.296470@n67g2000cwd.googlegroups.com>

newbert ha escrito:

> Alright, I found a solution to my own problem. This works, but it is
> very slow. Does anyone has a more graceful solution?
>
> SELECT locations_s.address as start_address, locations_e.address as
> end_address
> FROM rides, locations locations_s, locations locations_e
> WHERE locations_s.location_key = rides.start
> AND locations_e.location_key = rides.end
> AND rides.ride_key = '8'

I cannot see why it is 'slow'. Could you provide the EXPLAIN PLAN? What about table sizes, PK's, FK's, indexes, statistics? (Not to mention SO, Oracle version etc, etc...)

Cheers.

Carlos. Received on Wed Dec 13 2006 - 03:49:40 CST