MVSFORUMS.com A Community of and for MVS Professionals    FAQ   Search   Quick Manuals   Register   Profile   Log in to check your private messages   Log in  Search found 1 match MVSFORUMS.com Forum Index Author Message   Topic: How to Optimize UNION Select? davinski_code Replies: 2 Views: 2277 Forum: Database   Posted: Wed Jul 26, 2006 6:23 am   Subject: How to Optimize UNION Select? Hi all, I have read some topics and I realized that a SELECT statement that uses UNION has some performance problems. This is what I am experiencing at the moment. Here is my SQL: ...   Page 1 of 1 All times are GMT - 5 Hours Jump to: Select a forum Announcements----------------MVSFORUMS - Announcements Help Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & A General----------------Tools and DownloadsIT News Technical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF  MVSFORUMS Powered by phpBB © 2001, 2005 phpBB Group