Re: GROUP BY vs DISTINCT

"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: Calculate days between 2 dates ignoring weekends?
    ... I sometimes compare Jet to SQL Server as an aside ... JamieC on Jet: "If this were Jet... ... 'classes' using the MOD operator" [Note SQL Server has no MOD ...
    (microsoft.public.access.formscoding)
  • Re: Creating a new Access database file (.mdb) in .NET/C#
    ... You definitely need to download my Ebook. ... It can be passed around as a file like JET and backed up in a similar fashion. ... Consider that this database is also fully encryptable--a feature not in JET or in SQL Server until 2008. ... Per the MS product pages, I'm eligible for the Upgrade package, and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Official Status of SQLServer 2005 ADP
    ... As far back as Access 97, Jet has made every attempt ... to "pass through" every Access query against a linked ODBC datasource. ... ends - DB2, Oracle, and SQL Server among others. ... > solution might be to use ADP. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Calculate days between 2 dates ignoring weekends?
    ... I sometimes compare Jet to SQL Server as an aside ... JamieC on Jet: "If this were Jet... ... 'classes' using the MOD operator" [Note SQL Server has no MOD ...
    (microsoft.public.access.formscoding)
  • Re: Calculated field in pass through query
    ... Server with logging to Jet without logging, you are not making a fair ... You could turn off the SQL Server logging and have a product ... perform query work at speeds more than 100 times what I can do with Jet. ...
    (microsoft.public.access.queries)