Subject Re: [ib-support] is FIRST 1 improve the speed with ORDER BY?
Author Helen Borrie
At 10:55 PM 22/05/2003 +0200, you wrote:
>Firebird for sorting without index build a data internaly
>,sort the records and send them to client
>but when use FIRST there is no need to build that data , just find th
>first record
>accepted the sort
>
>any one agree with me.
>
>sorry for poor english.

I'm not sure what you would achieve. You need a sorted set in order to get
anything meaningful out of SELECT FIRST... An index usually speeds up a sort...

Helen