Re: GROUP BY vs DISTINCT

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]))




Vanderghast, Access MVP

Relevant Pages

  • Re: OT: phishing issue
    ... Kinda makes me suspect that maybe, perhaps, just possibly this is ... Did you read the email in HTML format? ... Text) and see what the real link is. ...
    (alt.comp.anti-virus)
  • Re: G20 Police Assault - Disgraceful!
    ... govt. ... I suspect you would agree with this. ... If the 'behaviour' that you are referring to was endemic and meted out by the majority of officers policing the protest, ... That is not to excuse their actions - simply point out that it is not common practice. ...
    (uk.legal)
  • Re: Car DAB aerial.
    ... Excuse me, just what do you mean by "my sort"..? ... but I suspect that you are! ... For what it's worth, ...
    (uk.tech.broadcast)
  • Mets thinking long term?
    ... This Beltran "injury" seems suspect. ... slump. ... Maybe this is just an excuse to give him some extended rest, ...
    (alt.sports.baseball.ny-mets)
  • Re: Daughters web page - comments and help wanted
    ... spelling and grammar checkers, there is it's no excuse. ... I would hope that that was deliberate. ... However, sadly, I suspect that isn't the case. ...
    (uk.rec.motorcycles)