Thread: Re: Help with order by into a RECORD

Re: Help with order by into a RECORD

From
Richard Huxton
Date:
Shaun Clements wrote:
> Hi Richard
>
> I have a questions regarding my order by problem.
> If you index a table, can you query the table using ORDER BY. ?

You can ORDER BY any combination of columns/expressions, whether they
are indexed or not. An index may make things quicker (it isn't
guaranteed to do so).

--
   Richard Huxton
   Archonet Ltd