Re: Simple queries versus complex queries

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 28 Aug 1999 14:47:53 GMT
Message-ID: <37d3f66c.15945718@newshost.us.oracle.com>

A copy of this was sent to Norris <johnnie_at_cooper.com.hk> (if that email address didn't require changing) On 28 Aug 1999 10:57:00 GMT, you wrote:

>Microsoft states that "In some cases it is best to use a group of simple
>queries using temp tables to store intermediate results than to use
>a single very complex query".
>
>Is this true with the Oracle 8i temp table?

In general -- no. We would prefer a single query in most every case.

As with everything in life -- YMMV, it depends, sometimes...

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Aug 28 1999 - 09:47:53 CDT