Re: GROUP BY vs DISTINCT

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Ochoa To Play 1 More Tourney, Then Retire
    ... "family" excuse.? ... I suspect the boyish-looking ochoa is in fear of ...
    (rec.sport.golf)