Affect of table name order in SQL

From: Mike Prompovitch <prompom_at_mcln.unisysgsg.com>
Date: 1995/09/01
Message-ID: <DE8LyD.7A7_at_HAN.UnisysGSG.COM>#1/1

We have been tring to optimize some SQL statements and discovered that the order of the table names in the FROM clause affected the query time. I thought that Oracle would determine the best way to do the query; freeing us from deciding how to write the SQL statement. Has anyone else run across this problem?

We are running Oracle 7.1 on an N.T. platform.

Thanks
prompom_at_mcln.unisysgsg.com Received on Fri Sep 01 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Bill Manry - MainframeBmanryIntegration: "Re: AS/400"
Previous message: Steve Cosner: "Re: Runform sizing (Forms 4.5)"
Next in thread: Willy Klotz: "Re: Affect of table name order in SQL"
Reply: Halvor F. Hantoh: "Re: Affect of table name order in SQL"
Reply: Doug Harris: "Re: Affect of table name order in SQL"
Reply: Willy Klotz: "Re: Affect of table name order in SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message