-----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-----
