Subject | ORDER BY empty statement |
---|---|
Author | jasajona |
Post date | 2006-03-30T06:55:26Z |
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"
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"