Re: Access Paths: Will these produce equivalent results?
From: andrewst <member14183_at_dbforums.com>
Date: Sun, 11 May 2003 13:37:31 +0000
Message-ID: <2863674.1052660251_at_dbforums.com>
Date: Sun, 11 May 2003 13:37:31 +0000
Message-ID: <2863674.1052660251_at_dbforums.com>
Originally posted by --Celko--
> Oracle is still a lousy product without a very good optimizer, so it
> probably just plows thru the clauses in the order they are given,
> without making an attempt to see if a group column predicate can be
> moved into the WHERE clause, so that you do not have to build all of
> the groups, then retain only a few of them.
You really don't like Oracle, do you Joe? Are you seriously suggesting
that SQL Server is a BETTER product?
-- Posted via http://dbforums.comReceived on Sun May 11 2003 - 15:37:31 CEST