Quote:
Originally posted by Chintz
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
This is a simple sql select statement that could be just derives from views with maybe from underlying views/table(as what gandolf is trying to say).