 |
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 4 matches |
| Author | Message |
|---|---|
 Topic: Need tips for tuning below mentioned queries |
|
| mainframes530 Replies: 14 Views: 6271 |
 Forum: Database Posted: Tue Mar 18, 2008 12:44 pm Subject: Need tips for tuning below mentioned queries |
| @Nic Clouston
Thanks a lot,i will definitely do some research on EXPLAIN @ CraigG, thanks a lot craig,i completely agree with what ever u said regarding Code: WHERE B.EFCT_DATE < :HV-END ... |
|
| Topic: Need tips for tuning below mentioned queries |
|
| mainframes530 Replies: 14 Views: 6271 |
Forum: Database Posted: Sun Mar 16, 2008 4:27 am Subject: Need tips for tuning below mentioned queries |
| CraigG,
thnks.table contains 7 million records.it is taking around 5-6 hrs. |
|
| Topic: Need tips for tuning below mentioned queries |
|
| mainframes530 Replies: 14 Views: 6271 |
Forum: Database Posted: Sun Mar 16, 2008 4:25 am Subject: Need tips for tuning below mentioned queries |
| bauer,
thanks for your reply, Could you please more specific about how to use explain? provide material for the same. |
|
| Topic: Need tips for tuning below mentioned queries |
|
| mainframes530 Replies: 14 Views: 6271 |
Forum: Database Posted: Fri Mar 14, 2008 6:40 am Subject: Need tips for tuning below mentioned queries |
| Hi.
my cobol pgm contains 2 cursors which are taking lot of time to execute.could any one help me in optimizing the below queries. 1) SELECT A.ZDS_SP, ... |
|
All times are GMT - 5 Hours |