-
SQL Tuning
Guys/Gals,
Would like your help here. I am not a SQL Tuning guru but I have to tune this SQL. Please help ..
SELECT a.operator
, a.run_id
, a.f_batch_prefix
, b.oprid
FROM batch_vg a
, oprdefn b
WHERE b.oprid = a.oprid
AND substr(a.run_id,1,2)='04';
Tell me in which way can this SQL be written better. Right now when this SQL is run it times out.
All input will be highly appreciated.
Chintzs
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|