Re: Anything I can do to speed up this query?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 12/06/06 16:34, Wei Weng wrote:
> On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
[snip]
> I think I have discovered the reason for why the query runs so slow. The
> original query has an ORDER BY Field1 clause that I forgot to put in my
> email.
>
> So the query looks like this:
>
> SELECT Field1, Field2, Field3... FieldN FROM TargetTable ORDER BY Field1
> DESC;
>
> What is the effective way to optimize this query(or to optimize the
> system) to run a little faster than it does now?
>
> Thanks and I really appreciate all the helps I've gotten so far.

Is the index ASC or DESC?

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFd3sLS9HxQb37XmcRAttuAKCnSEXoXcK+CCCaa3yIX+FXS/NqtwCgzlZS
IQ4C7hbsCXiFLGkhrPQGGUA=
=4z9T
-----END PGP SIGNATURE-----