Re: Access Paths: Will these produce equivalent results?

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.com