View Single Post

   
  #2 (permalink)  
Old 04-18-2008, 10:47 AM
Stephen Frost
 
Posts: n/a
Default 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-----

Reply With Quote