SQL Performance (MOSC)

MOSC Banner

sql query runs long time and always seem to fill out temp

edited Apr 2, 2014 12:00PM in SQL Performance (MOSC) 6 commentsAnswered


The developer is trying to execute a query for report purpose. The query seems to run four a long time and always seem to fill out the temp tablespace. I did added another 1Gb to the temp tablespace, but still filled up. Gurus, please advise whether this query needs tuning or is having syntax issue maybe. Thank you very much.

Below is the query:

select productinfo.serial_no,
testdata.tst_rvalue, testdata.tst_judge, testdata.upd_date from t_prd_info
productinfo, t_tst_data testdata

where testdata.upd_date >=
to_date('03/20/2014', 'mm/dd/yyyy')

and testdata.tst_id = '123456'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center