Tuning

From: ALTAIR, RSP_4 <RSP_4.ALTAIR_at_EU.RHODIA.COM>
Date: Mon, 19 Jun 2000 14:08:38 +0200
Message-Id: <10533.109696@fatcity.com>

Hi,

How can i optimize this sql statement ?

SELECT ID_TABLE1,TNAME,ID_SUB_LOCATION4,NAME4,ID_SUB_LOCATION3,NAME3,

              ID_SUB_LOCATION2,NAME2,ID_SUB_LOCATION1,NAME1 FROM
	  TABLE1,LOCATION4,LOCATION3,LOCATION2,LOCATION1 
              WHERE TABLE1.ID_SUB_LOCATION4=LOCATION4.ID_SUB_LOCATION4
              AND LOCATION4.ID_SUB_LOCATION4=LOCATION3.ID_SUB_LOCATION4
              AND LOCATION3.ID_SUB_LOCATION3=LOCATION2.ID_SUB_LOCATION3
              AND LOCATION2.ID_SUB_LOCATION2=LOCATION1.ID_SUB_LOCATION2;

Any ideas would interest me ! Thanks

Seb

The structure is below :

TABLE1
{ ID_TABLE1 NUMBER

    TNAME VARCHAR2
    ID_SUB_LOCATION4 NUMBER } LOCATION4
{ ID_SUB_LOCATION4 NUMBER

    NAME4 VARCHAR2
    ID_SUB_LOCATION3 NUMBER } LOCATION3
{ ID_SUB_LOCATION3 NUMBER

    NAME3 VARCHAR2
    ID_SUB_LOCATION2 NUMBER } LOCATION2
{ ID_SUB_LOCATION2 NUMBER

    NAME2 VARCHAR2
    ID_SUB_LOCATION1 NUMBER } LOCATION1
{ ID_SUB_LOCATION1 NUMBER
Received on Mon Jun 19 2000 - 07:08:38 CDT