Re: GROUP BY vs DISTINCT

My God what a pair of idiots (I mean Walsh and Warrio, not you David).

Probably better to let these two fools massage each other's egos in French
while we go and do something more worthwhile.

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns9942A6C92A914f99a49ed1d0c49c5bbb2@xxxxxxxxxxxx
"Michel Walsh" <vanderghastArobaseMsnDotCom@xxxxxxxxxx> wrote in
news:#RDAQaHpHHA.716@xxxxxxxxxxxxxxxxxxxx:

and here is the query plan, again, the same, for both statements
(excuse the HTML format, I suspect that without it, it turns out
un-readable):

|--Sort(DISTINCT ORDER BY:([pubs].[dbo].[authors].[au_fname]
|ASC))

|--Index Scan(OBJECT:([pubs].[dbo].[authors].[aunmind]))

Er, that's a SQL Server query plan, not a Jet one.

Who said we were using SQL Server as the back end?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/


.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... I'm willing to continue because I need this database to be up and working on ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... tomorrow to see where the log files are. ... SQL Server 2000 SP4 is 8.00.2039. ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: Move or Setup of SQL Database toa Remote Server Fails
    ... Windows Server System MVP - SMS ... David Baur wrote: ... Could not verify SQL Server is clustered or not because the setup could not connect to the SQL Server 501ST or failed to run the query. ... The SCCM Primary Site Computer Account and the User account I am using are both sysadmin on the Remote SQL Server, and have sysadmin on Master as well. ...
    (microsoft.public.sms.setup)
  • Re: Exception in xa_open with SqlServer 2000 SP3a on Win 2003
    ... | David S. Faller wrote: ... The list of post-SP3 updates of SQL Server does not ... |>> implements the extended stored procedures thet SQLServer uses for XA. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Log shipping and index rebuilds
    ... Lisa, thanks very much for your reply. ... David Bailie ... > SQL Server 2000 High Availability. ... >> If we were to ship index rebuilds, we'll be shipping gigabytes of unnecessary data, but apparently SQL Server will not let this be switched off? ...
    (microsoft.public.sqlserver.server)
Loading