[SQL] Bug with DISTINCT?

[Robert Brenstein]

>on 1/16/04 1:58 AM, Eric Forget at forgete at cafederic.com wrote:
>
>>>  Please note,
>>>
>>>  RecID field not works correctly if you use it in ORDER BY.
>>
>>  So when I query "SELECT DISTINCT RecID ..." there is in implicit "ORDER BY
>>  RecID"? Is it what you means?
>
>Yes.
>
>DISTINCT always must sort records at first.
>
>Then it throw out the same records.
>

So DISTINCT will also create index, if one is not there, right? This 
should be mentioned in docs, shouldn't it?

Robert