Re: Improve performance of query * Richard Rowell (richard@bowmansystems.com) wrote:
> I have included an EXPLAIN ANALYZE, relevant table counts, and relevant
> indexing information. If anyone has any suggestions on how to improve
> performance.... TIA!
Just a thought- do the UNION's actually have to be union's or would
having them be 'UNION ALL's work?
Stephen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQFBwb+arzgMPqB3kigRAjmVAJ9HOb0yZZ8L8hmL4JVurB r7ZC4yQwCeL32M
9rb52sFyjs5Ij3+K9ILXBE8=
=SNzJ
-----END PGP SIGNATURE----- |