jasajona schrieb:

> Hello,
>
> I am developing UI components for firebird. Just now found out that
> sometimes on big tables with many joins ORDER BY slow down execution
> several times.
> Are there any way to leave ORDER BY statement without any fields
> listed in it? Something like this:
>
> SELECT
> *
> FROM
> table1
> ORDER BY
>
> WHERE
> field1 = 100
>
> I tryed "ORDER BY -1" it is not rising an error but it slowing down
> query execution as would be "ORDER BY 1"

If you don't need an ORDER BY you're not allowed to use the keyword.
So there is no way to leave it.

ORDER BY -1 is absolute nonsense since ORDER BY [number] identifies the
field index (starting with 1) in the select clause which should be used
for ordering.

Luc.