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