It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks
"Kevin King" <[EMAIL PROTECTED] To: [EMAIL PROTECTED] > cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG difference. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, August 08, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [U2] Question on Unidata tables access speeds Hi , Project data warehouse, Sources are Unidata tables, tool Datastage. Performance issue, while dumping in to hash file(Allowing stage write cash). It is searching 5.5 million rows and fetching 2.6 million rows and taking 2.5 hours. There is only one key column in the ouput. When I remove select caluse(I mean select all rows) and put that filter in my tool, it is ok, but not great. After that When I run parallel jobs , I mean select the data by 4 jobs for different ranges(all at the same time), it is taking 4 times than normal time . In other words, I am not getting performance like Oracle or other data bases. I am new to Unidata, is there any method where I can get good access speeds on Unidata.Any help will be highly appreciated. thanks pbr ---------------------------------------------------------------------- -------- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. ====================================================================== ======== ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------------------------------------------------------------------------------ Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. ============================================================================== ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/